Run Method

expression    An expression that returns an Application object.

MacroName    Required String. The name of the macro, add-in, or script.

safeArrayOfParams    Required. A ParamArray of type Variant.

Example

The following example runs a macro from another procedure.

Note  To run this example, you must have a Web site named Rogue Cellars or you can substitute a different Web site in place of the Rogue Cellars Web site. Copy the following procedures into a code module and run StartMacro.

Private Sub StartMacro()
    Dim myMacro As String

    myMacro = "OpenRogueCellars"
    Run (myMacro)
End Sub

Sub OpenRogueCellars()
    Dim myWeb As Web

    Set myWeb = Webs.Open("C:\My Web Sites\Rogue Cellars")
End Sub