VBA Object or function to access Menu Bar button under ADD-IN

**Sahil1087** · 11-06-2012, 08:44 AM

Hi Everyone ,

I have installed one COM ADD-In in my excel having .dll extention.
I need to access that ADD-IN with help of Macro.

Can anyone tell me how to access this with help of VBA.

Thanks in advance.

Regards
Sahil Chaudhary

**JosephP** · 11-06-2012, 09:20 AM

you may need to talk to the developer-it depends on what you want to achieve. if you just need to click a toolbar button and nothing more then you can probably do it using the commandbars collection but you need to work out if the add-in creates its own toolbar or adds the buttons to an existing one

**Sahil1087** · 11-06-2012, 10:55 AM

Originally Posted by JosephP

you may need to talk to the developer-it depends on what you want to achieve. if you just need to click a toolbar button and nothing more then you can probably do it using the commandbars collection but you need to work out if the add-in creates its own toolbar or adds the buttons to an existing one

Hi , I have already tried with Commandbar collection. From CommandBar collection I can access Add-In but not COM-Add-Ins.

Please correct me if its possible to access COM-Add-in via CommandBar collection.

**Sahil1087** · 11-09-2012, 01:41 AM

Hi , is there anyone on this forum who is aware of how to access COM Add-In having .dll extention.

I have tried with commandbar but I am not able to access COM Add-In button in excel via VBA.

**JosephP** · 11-09-2012, 06:03 AM

if the control appears on the addins tab then you can almost certainly access it from the commandbars collection as long as you know which commandbar it was added to. there is no difference between an add-in and a com add-in in that regard