Office 2002 uses 10.0 libraries
Office 2003 uses 11.0 libraries
Office 2007 uses 12.0 libraries

You have a choice in any version to select the latest version or a previous
version. If yo have 2007 and want 2003 and 2007 to use your code select the
highest common version.


"Beans" wrote:

Hi,

I have just upgraded to Vista and Office 2007 and when I loaded my add-in it
seemed to work OK.

To solve some problems with Outlook I was forced to uninstall and reinstall
Office. No my add-in gives me an error that states "Object library invalid
or contains referenced to object definitions that could not be found".

How do I find out what object libraries I need to load?

Below if the shortest of the macros that give me the error.

Sub DeleteMyMenu()
Dim MU As CommandBarPopup
On Error Resume Next
Set MU = Application.CommandBars(1).Controls("&My Tools")
MU.Delete
End Sub

I have the following references selected:
Visual basic for applications
Microsoft Excel 12.0 Object library
OLE Automation
Microsoft office 12.0 Object library

Any assistance will be appreciated.

Regards.

Sean