Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Macro from objApp Application object
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Macro from objApp Application object
Lance Hoffmeyer wrote:
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"}); |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running a macro from windows application | Excel Discussion (Misc queries) | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming | |||
how to get hwnd from application object? | Excel Programming | |||
Application Error when running Macro on Workbook open | Excel Programming | |||
Application Error when running Macro on Workbook open | Excel Programming |