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'm a bit of a noob on this, but maybe this will help :

http://msdn.microsoft.com/en-us/library/aa159923(office.11).aspx

For anyone that needs to know (I didn't know this!):


To add an object library for any office program to your VBA References in Access (or any other program I would assume), do the following:

1) VBA editor > Tools > References > Browse to Path of Program Executible
2) Example - Path for 2003 Office Excel is: C:\program files\microsoft office\office11\excel.EXE


Just sharing my knowledge with the rest. I never had to do this before. It must have something to do with me having both 2003 and 2007 version on the same machine!