VBA project and ActiveX controls

[panatulhalie]

Dear All,

I have upgraded Excel from '97 to 2000. When I start Excel I get the
following error:

"This workbook has lost it's VBA projects, ActiveX controls and any
other program ability related features".

Can someone tell me what to do?

Regards,

Paul

 

[Dave Peterson]

I'd go back to xl97 (find a pc still running that version???) and then export
all the code--it's good to have that saved somewhere safe.

I'd try running Rob Bovey's code cleaner program.
You can find it here:
http://www.appspro.com/

(It exports all the modules, deletes the modules and reimports it.)

Then save that as a new name (first, do no further damage to the original).

Then try opening the workbook in xl2k.

If that doesn't work, maybe you could try to find a copy of xl2002+ to see if
opening|saving it there would help. (xl2002+ has a better reputation of opening
workbooks that earlier version could not.)

And if it is a corrupted workbook, you may want to try openoffice. Lots of
people have said that it's recovered workbooks that excel couldn't.

(http://www.openoffice.org, a 60-65 meg download or a CD)

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com

 

[panatulhalie]

Thanks for your reply!!

I have tried something else that also works. I have installed the
component VBA (Visual Basic for Applications) from the MS Office
cd-rom.

Thank you for your help and time!!

Greetings,

Paul