VBA to select a custom add-in menu item

[Chris Davison (VBA)]

is it easy to code the selection of a menu item ?

I have a couple of custom add-ins that have their own menu items (in fact, it's very similar to what you see with Colo's HTML addin in the menu)

how would I code the selection of "HTML", "Convert Sheet to HTML" that we normally just do with a mouse ?

When I record it with the macro recorder, it doesn't show up at all

many thanks
Chris

 

[Andrew Poulsom]

You just need to call the procedure assigned to the menu item.

 

[Chris Davison (VBA)]

On 2002-09-18 01:28, Andrew Poulsom wrote:
You just need to call the procedure assigned to the menu item.

thanks ANdrew, I get "sub or function not defined...."

it's in it's own module, obviously in it's own XLA file seperate from my module in my worksheet file

how do I call a procedure from such a location ?

[these aren't my menu items by the way, they are customised add-ins that come with our accounting package and a lot of the VBA that sits behind them is hidden away from view unfortunately...)

cheers
Chris

 

[Andrew Poulsom]

You may be able to use the Run method like this:

Application.Run "MyAddin.xla"!MySub"

Change what's in quotes to suit.

If you use Tools, References in the VBE to establish a reference to the Add-In you can omit the name qualifier. You can also call it directly unless it's declared as Private.

You can use the Object Browser to find procedures in the Add-In. Select the Add-In in the Project window and activate the Object Browser. Find it in the Libraries dropdown and the Classes and Members will be displayed below.

 

[Chris Davison (VBA)]

great stuff.... that's really helpful

VBA beginner here, in case you hadn't twigged :wink: