typelib for Excel 2003
Posted on 2006-05-15
I'm sitting here in Access and have automated Excel objects using the reference C:\Program Files\Microsoft Office\Office\Excel9.OLB which is a type library. Everything works nicely with that typelib.
My client has Office 2003. Shamefully, I do not.
If I ship the Excel9.OLB which works so nicely here with the app I am developing (the .mdb), I betcha when it gets to his PC with Office 2003 it won't work. The first thing which will happen is it won't find an implementation of Excel interfaces in C:\Program Files\Microsoft Office\Office\ because doesn't the Office 2003 version live in C:\Program Files\Office10\Excel.exe.
It looks like last time I did this kind of thing I gave the client an .mdb with a reference to C:\Program Files\Office10\Excel.exe which I guess has the typelib built into the .exe.
Will that work again? I want to be saved the embarrassment.