asked on

VISUAL BASIC ERROR WHEN OPENING EXCEL SPREADSHEETS

I have two computers. One runs Win2k, and the other runs WinXP. When I open an Excel spreadsheet on the XP machine, I get a MS Visual Basic error "System Error &H8007007E (-2147024770). The specified module could not be found."

Then a VB debugging window opens. I then get a MS VB Out of Memory error. After I close the error and the debugging window, I can view the spreadsheet with no problem. But, how do I stop this from happening? I do not get this error on my Win2K machine.
I have already tried CCleaner with no effect.
Thanks!

Brian Mulder

Hello LEECHIPTURNER,

Hello rmallach,

--------------
the autostart folder for automatically included add ins for excel is
C:\Documents and Settings\YourUserName\Application Data\Microsoft\Excel\XLSTART

check that folder and eventually move the addins to another place to see if excel is able to start
--------------

also check up on
source: http://support.microsoft.com/default.aspx?scid=kb;en-us;280504

hope this helps a bit
bruintje

Patrick Matthews

Hi Brian,

> the autostart folder for automatically included add ins for excel is

Just a note--that folder is a general "open these files when UserX launches Excel", and is not necessarily restricted to
add-ins. Personal macro workbooks typically go here, for example...

Regards,

Patrick

LEECHIPTURNER

ASKER

Thanks, but there is nothing in the XLSTART folder. How do I turn off Visual Basic? It seems to be generating the error. It doesn't happen when I open Excel. Only when I load a spreadsheet.

ASKER CERTIFIED SOLUTION

zamiv

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Brian Mulder

the kb article gives a list of steps to perform in search for a solution

Pandorasink

What resolved this for me was running detect & repair.