VBA project and ActiveX controls

  • Thread starter Thread starter panatulhalie
  • Start date Start date
P

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
 
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
 
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
 
Back
Top