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

 

[KyleS]

OK,
Well since you don't seem to have a workbook variable set to the open book I guess this should work.

Workbooks.ActiveWorkbook.RunMacro "MyMacro"

In access I set a variable = to the workbook and use

MyVar.RunMacro "MyMacro"

Hope this helps

Kyle

 

[bengalliboy]

Thanks a lot@ This worked@