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
mklikAsked:
Who is Participating?
 
DaveConnect With a Mentor Commented:
Try removing the Missing Reference prior to Browsing to the location and selecting OWC11.DLL

0
 
DaveCommented:
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


0
 
mklikAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.