Application.Run

G

greg

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
 
P

Peter T

Sure -

sMacro = "myAddin.xla!mod_Procs.myMacro"
Application.Run sMarcro, arg1

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling Functions In Global AddIns 5
Execute a macro in another file with an argument 1
Application.Run "[TemplateName].[ModuleName].[MacroName] 3
Ending Procedure When Condition is Met Anywhere in Procedure 2
Array with many cells from a row but not in order or together 11
Input box help needed 3
Add-In Calls Sub in Active Workbook 2
Code to open MS Excel and run macro 10

Top