Excel 2000: An Error Occured Initializing the VBA Libraries (2)

[darrenjmccabe]

Very odd one this and am not holding out much hope, but then you never
know.

We have a massive spreadsheet we use that was fine until a user tried
to get into it last night and received the following error:

An Error Occured Initializing the VBA Libraries (2)

Now we cannot access the file at all, I have managed to restore the
previous nights backup, but they have lost a ton of work that was put
into it yesterday.

The file size has also changed from 3Mb to 512Kb, which is very odd.

As I said, I am not hopeful on this one, but if someone can help it
would be greatly appreciated.

 

[Dave Peterson]

Just guesses...

I would start by reregistering excel.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

If that doesn't work and it's only this one file that's having trouble, I'd try
to open it in OpenOffice to see if my data could be saved--if it opens, maybe
save it as a new .xls file to see if excel could open the newer file.

http://www.openoffice.org, a 60-104 meg download or a CD

Very odd one this and am not holding out much hope, but then you never
know.

We have a massive spreadsheet we use that was fine until a user tried
to get into it last night and received the following error:

An Error Occured Initializing the VBA Libraries (2)

Now we cannot access the file at all, I have managed to restore the
previous nights backup, but they have lost a ton of work that was put
into it yesterday.

The file size has also changed from 3Mb to 512Kb, which is very odd.

As I said, I am not hopeful on this one, but if someone can help it
would be greatly appreciated.