"stdole2.tlb" missing or damaged

[dss_cottage]

It's a long and convoluted story as to why I'm doing this and I won't bore you with that.

I recently bought a new computer with Windows 8 Pro.

1. I installed MS Office 97 and it was working perfectly.
2. I then installed MS Office 2007 and subsequently changed it to "make Excel 2007" unavailable. (i.e. I need to use Excel 97 not 2007)

After I did #2 and I open Excel 97, I get the error message "One of your object Libraries (stdole2.tlb) is missing or damaged. Please run setup to install it."

I click "OK" and other than opening full screen rather than in a normal window, it seems to run perfectly.

I searched for "stdole2.tlb" and found it in 4 locations. The date on the file is "July 25, 2012". I checked another computer that is running Excel 97 and Win XP and the date of its "stdole2.tlb" file is Aug 4, 2004.

I'm tempted to uninstall Office 97 and just re install Excel 97 but I doubt that this will work since the "stdole2.tlb" date doesn't seem to be related to either version of Office.

Can anyone suggest a solution?

[Sisyphus]

Hello dss_cottage,
Welcome to the forum!
I did a little research on your question and didn't find any mention of different versions of the file. Indeed, the problem you have may be related to the fact that you have several versions of the file on your PC - a registry problem. I found instructions to deal with this at this link:-

Code: Select all

http://www.mrexcel.com/forum/excel-questions/264454-stdole2-tlb-missing-damaged.html

[dss_cottage]

Sisyphus,

Thank-you for the reply.

I tried that but it didn't work.

Ultimately, I uninstalled Office 97 and re-installed Excel 97 only.

Excel 97 then worked perfectly but after that every time I opened Word 2007 I got a "Configuration Process" window and a progress bar that lasted for about 30 seconds. Then Word operated correctly.

This was corrected by adding the following to the registry:
reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1

Now all is working perfectly.