Executing Macros

[Eddie Wildon]

Simple question (I hope): What is the syntax in vbscript to excecute a macro?

 

[Richie(UK)]

Hi Eddie,

If you want to execute Sub2 from within Sub1 then use the Call statement, like this:

Sub Sub1()
    MsgBox "Part1"
    Call Sub2
    MsgBox "Part3"
End Sub

Sub Sub2()
    MsgBox "Part2"
End Sub

Highlight the word Call while in the VBE and press F1 to get the info from the Help files on this topic.

HTH

 

[Eddie Wildon]

worked like a top. I was able to embed and call macros from a number of different points in the code. If it wasnt hard to tell, i'm a rook at this so I really do appreciate the help.

James