Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
That is the kind of thing that I would have expected. What is confusing is that my add-in loaded OK under the OEM install and it seemed to work. The menus and toolbars appeared under the Add-in ribbon. I am thinking that there must be some setting that is different now that I have done an reinstall. Thanks for the link to the ribbon editing helper. I will have to look at that. I was just hoping to get the thing working again like it was under the OEM install until I can find the time to look into the ribbon. Thanks. Sean "Barb Reinhardt" wrote in message ... FWIW, Command bars are no longer used in Excel 2007. You'll need to modify the ribbon to do what you want. Ron DeBruin has put something together on editing the ribbon if you want to go there. http://www.rondebruin.nl/ribbon.htm You'll need to check for the application version If Val(Application.Version)=12 then 'Do your Excel 2007 stuff. else 'Do your Excel 2003 or less stuff. end if HTH, Barb Reinhardt "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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please Help on Object Library Invalid or contains.... | Excel Programming | |||
object library or invalid reference | Excel Programming | |||
Object library Invalid | Excel Programming | |||
Object library Invalid | Excel Programming | |||
object library invalid | Excel Programming |