ajetrumpet
Banned
- Local time
- Yesterday, 21:23
- Joined
- Jun 22, 2007
- Messages
- 5,638
All,
I am looking for the location of the Object Library File for the 2003 version of Excel (the reason - when opening Excel application from Access VBA, it opens 2007 - I have the "Office 12" library loaded in the reference list). I think I am in the right place, but I only see 4 OLB Files in my Office 11 folder. There is one for WORD, POWERPOINT, and ACCESS. Is Excel in a different place? Thanks! (The picture attached is sorted by file type, and all OLB files are highlighted.)
EDIT
I added the "XL" type OLB that you see in the picture, but I don't think that is it, because it didn't appear in my reference list when I added it in from the BROWSE button.
I am looking for the location of the Object Library File for the 2003 version of Excel (the reason - when opening Excel application from Access VBA, it opens 2007 - I have the "Office 12" library loaded in the reference list). I think I am in the right place, but I only see 4 OLB Files in my Office 11 folder. There is one for WORD, POWERPOINT, and ACCESS. Is Excel in a different place? Thanks! (The picture attached is sorted by file type, and all OLB files are highlighted.)
EDIT
I added the "XL" type OLB that you see in the picture, but I don't think that is it, because it didn't appear in my reference list when I added it in from the BROWSE button.