Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run
Hello,
I have been looking at Application.Run I see the following code in MSDN. In this example they use a template name. Does that mean a template can be not opened? And it will run a method from any template? How about an add-on? how about an xla? can you have: Application.Run MacroName:=<<xla& "." _ & <<module1 & "." & <<some method ?? strTemplate = InputBox("Enter the template name") strModule = InputBox("Enter the module name") strMacro = InputBox("Enter the macro name") strParameter = InputBox("Enter a parameter value") Application.Run MacroName:=strTemplate & "." _ & strModule & "." & strMacro, _ varg1:=strParameter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Run
Sure -
sMacro = "myAddin.xla!mod_Procs.myMacro" Application.Run sMarcro, arg1 Regards, Peter T "greg" wrote in message ... Hello, I have been looking at Application.Run I see the following code in MSDN. In this example they use a template name. Does that mean a template can be not opened? And it will run a method from any template? How about an add-on? how about an xla? can you have: Application.Run MacroName:=<<xla& "." _ & <<module1 & "." & <<some method ?? strTemplate = InputBox("Enter the template name") strModule = InputBox("Enter the module name") strMacro = InputBox("Enter the macro name") strParameter = InputBox("Enter a parameter value") Application.Run MacroName:=strTemplate & "." _ & strModule & "." & strMacro, _ varg1:=strParameter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Execute a Macro from one excel Application to another Application | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |