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

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