Invoking a function in Excel+VBA code from a DLL

[SudarsanK]

Hi,

I need to invoke a VBA function from a dll.

My scenario is as follows.

I'm working with Excel and have a Smart Tag menu(my own written in a dll). I want to invoke a VBA function when the user clicks on any of the menus.

Is this possible ?? If yes then pl. help.

Regards,

Sudarsan.

[RobDog888]

Welcome to the Forums.

Depends if you exposed it in your dll. If so you go to the VBA Editor
and add a reference to your dll. Then you should be able to
access the functions in it.

HTH