Storing a Macro name in a Variable

[Jack Adams]

Is there a way to store the name of a macro (with or
without parameters) in a named variable and then activate
the macro using the variable reference name?

Thanks,

Jack

This doesn't work but is waht I am trying to accomplish

Dim xMacro
xMarco = "ApplicationName"

Application. run ApplicationName

Likewise for a macro with parameters

 

[Geof]

Jack,
If it's a VBA procedure, try Call xyz(). If it has
parameters try Call xyz(prm1, prm2). Or do you really want
to run Excel 4 mactos?
Geof.

 

[Tom Ogilvy]

Dim xMacro
xMacro = "ApplicationName"

Application.run xMacro


Sub Macro1(x, y)
MsgBox x & " " & y
End Sub

Sub Macro2()
Dim xMacro
xMacro = "Macro1"
Application.Run xMacro, "StringArg1", 29
End Sub