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 wrote:
>
> 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
>
> --
> panatulhalie
> ------------------------------------------------------------------------
> panatulhalie's Profile: http://www.excelforum.com/member.php...o&userid=24293
> View this thread: http://www.excelforum.com/showthread...hreadid=378976

--

Dave Peterson

[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