How to Call an Excel VBA Macro

[bengalliboy]

Hi,
I am trying to call an Excel VBA macro from a VB program.

I got an excel file that got a macro (MyMacro). I can open the excel program fine using the following command:
--------------------------------------------
Workbooks.Open FileName:= _
"C:\MYTEST\Macro_Visio\TNT_DB.xls"
--------------------------------------------
But I don't know how to excute the Macro...
Can any one help plz. Thanks

 

[asjeff]

In a VBA application we would use something like:
Application.run "Macroname"

I presume you have to make sure you refence the Excel application and then run it.

Hopoe this helps

asjeff

 

[bengalliboy]

tHANKS THIS HELPED!