mklik
asked on
How to add reference to MS office web components 11.0?
I have an excel spreadsheet containing vba. It is running fine in Excel 2007, but when opening it up in Excel 2003, I get a "missing reference" error, asking for microsoft office components 11.0 (see image).
Which file am I looking for (and in which folder should I search) when I manually want add this reference in the VB editor? I already installed the necessary file from the microsoft website.
AddReference.JPG
Which file am I looking for (and in which folder should I search) when I manually want add this reference in the VB editor? I already installed the necessary file from the microsoft website.
AddReference.JPG
ASKER
Yes, that is the file I downloaded. Unfortunately, although the OWC11.DLL file was in the folder you mentioned, the reference still shows as MISSING after selecting it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This places the files into C:\Program Files\Common Files\Microsoft Shared\Web Components\11
Simply click Browse above , goto this folder and select OWC11.DLL
Cheers
Dave