Visual Basic error when launching Excel 2000

[c1utch]

I have several users in our finance department that are experiencing the same issue.

When they open Excel 2000, either by launching the executable directly or by opening an Excel document, they receive the following error:

Microsoft Visual Basic

System Error &H80070057 (-2147024809). The parameter is incorrect.

If they click on the "OK" button for this error message, they are then presented with the next error message.

Microsoft Visual Basic

Out of memory

Now, if they click "OK" to this error message, they can continue on with their work and use Excel as normal. So this error is just a nuisance.

I've looked around on the web for a resolution, but it seems most of them point to things you're trying to do in Visual Basic itself, rather than an Excel error.

With that being said, I guess it's possible some "Power User" changed a setting on a shared excel document...which in turn has made a change to the default settings of every other user that has opened this shared file. Either way, I can't seem to get this error message to go away.

Anyone have any ideas or experience to shoot my way?



Chris

 

[CautionMP]

The most likely suspects:[ol][li]Custom toolbar that is corrupt (*.xlb).[/li][li]Corrupt Add-in (*.xls).[/li][li]Something with the DDE parameters in the registry is wrong.[/li][/ol]
Both 1 and 2 usually reside on a user's local machine. If you have/had some macro writers this is worth looking at since they load automatically when Excel is launched. With O2k in WinXP they are usually found in:[ul][tt][li]C:\Documents and Settings\Username\Application Data\Microsoft\Excel[/li]
[li]C:\Documents and Settings\Username\Application Data\Microsoft\Excel\XLSTART[/li][/tt][/ul]
Number 3 is a little trickier. We ran into this anout 18 months ago and I don't remember the symptoms, cause, or solution. I do remeber that all we had to do was add/remove a set of quotes in couple of registry keys and the problem was corrected.

Not an answer: more of a direction,
CMP


Instant programmer, just add coffee.