PDA

View Full Version : How to access menu items of Excel add-in?



musicgold
03-29-2010, 06:58 AM
Hi,

I use an Excel plug-in from a third-party developer. The plug-in shows up as an additional menu item on my Excel along with Excel’s typical menu.

I need to click on the menu item and then click on two other submenus to perform a task. I wish to automate this task through a macro. How can I do that?

I also checked the folder where the files related to the plug-in are stored and it contains one xla file and a bunch of dll files.

Thanks,

MG.

Bob Phillips
03-29-2010, 08:07 AM
If you can find the name of the functions that you need to run, you could set a refernec to the addin in your project, then just call the functions.

musicgold
03-29-2010, 08:32 PM
xld,

Thanks. I don't know how to get the name of the function. The button itself says 'Refresh'.

To make the matter simple, how would you call the 'validation' sub-menu under the 'data' menu of Excel?

Bob Phillips
03-30-2010, 02:08 AM
Like this



Application.CommandBars(1).Controls("Data").Controls("Validation...").Execute