Running Macro from objApp Application object

[Lance Hoffmeyer]

SO, if I create an application obhect, objExcelApp
how would I run a macro from the workbook
macro.xls called addnewsheet?

macro.xls!addnewsheet






Sub CreateExcel()
Set objExcelApp = GetObject(,"Excel.Application")
objExcelApp.Visible = True
objExcelApp.Workbooks.Add
End Sub


Lance

 

[tommy]

SO, if I create an application obhect, objExcelApp
how would I run a macro from the workbook
macro.xls called addnewsheet?

macro.xls!addnewsheet






Sub CreateExcel()
Set objExcelApp = GetObject(,"Excel.Application")
objExcelApp.Visible = True
objExcelApp.Workbooks.Add
End Sub


Lance

//this is in C#

objExcelApp.GetType().InvokeMember("Run",
System.Reflection.BindingFlags.Default |
System.Reflection.BindingFlags.InvokeMethod,null, objExcelApp, new
Object[]{ "'macro.xls'!addnewsheet.addnewsheet"});