Link to home
Start Free TrialLog in
Avatar of mklik
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
Avatar of Dave
Dave
Flag of Australia image

Presumably you downloaded owc11.exe.

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


Avatar of mklik
mklik

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
Avatar of Dave
Dave
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial