Run Method Example

This example prompts the user to enter a template name, module name, macro name, and parameter value, and then it runs that macro.

t = InputBox("Enter the template name")
md = InputBox("Enter the module name")
m = InputBox("Enter the macro name")
p = InputBox("Enter a parameter value")
Application.Run MacroName:=t & "." & md & "." & m, _
    varg1:=p