Office Type Libraries

[Databaseguy]

There's been many posts about automating using office and VBA. A lot of times, we'll tell the person submitting the question to make sure they've included a reference to the type library in their VBA project. However, sometimes the library you need isn't listed. Here's the file names and associated type libraries if you have to browse for it:

Office Application | Type library
------------------------+----------------
Word 95 and prior | wb70en32.tlb
Excel 95 and prior | xl5en32.olb
Powerpoint 95 and prior | Powerpoint.tlb
Access 95 and prior | msaccess.tlb
Binder 95 | binder.tlb
Schedule+ | sp7en32.olb
Project | pj4en32.olb
Team Manager | mstmgr1.olb
Word 97 | msword8.olb
Excel 97 | excel8.olb
Powerpoint 97 | msppt8.olb
Access 97 | msacc8.olb
Binder 97 | msbdr8.olb
Graph 97 | graph8.olb
Outlook 97 | msoutl8.olb
Outlook 98 | msoutl85.olb
Word 2000 | msword9.olb
Excel 2000 | excel9.olb
Powerpoint 2000 | msppt9.olb
Access 2000 | msacc9.olb
Outlook 2000 | msoutl9.olb
Word 2002 | msword.olb
Excel 2002 | excel.exe
Powerpoint 2002 | msppt.olb
Access 2002 | msacc.olb
Outlook 2002 | msoutl.olb

 

[Dreamboat]

You should post this type of information as an FAQ and not as a question. Questions get old, FAQs stay in the FAQ list. Copy your post above, get back to the question list, and click on the FAQ tab and create an FAQ. It's terrific info, by the way!
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word