How to run an excel macro in VB.NET 1

[jonx]

Hello, I have an excel macro defined within an excel workbook, in other words if I push alt+F8 in Excel with that workbook, the macro will automatically run. Is there a way I could run this macro from VB .NET?

Thanks

 

[Kris11]

Jon,

You can use following code to run the macro from .NET

'Run the macro
excelBook.Application.Run("Main")

Here Main is the macro name that Excel workbook has.

-Kris

 

[Kris11]

Also when I was trying to implement the same I had spent sometime researching various options available to achieve this. If you scroll all the way down to the following thread thread796-319126, you can see the details of how I achieved this.

-Kris

 

[jonx]

Thanks