How to launch a MS macro from a VBA program?

[JPBernoux]

I have been working a while on this issue going nowhere. Any help would be appreciated. In a nutshell I want to execute a MS macro from a VBA procedure which is part of an Excel sheet. It boils down to:
How to execute VBSript from VBA?
The excellent MS manual shows how to execute VBA from MS macros but I just want to do the opposite...

[Monkster]

The VBA Shell Function should do the trick.

Shell "C:\Program Files\Macro Scheduler\msched.exe myScript.scp", vbNormalFocus

or

Shell "C:\Program Files\Macro Scheduler\msched.exe C:\Temp\myScript.scp", vbMaximizedFocus

etc.

[JPBernoux]

I had tried the shell command but directly with my sript which was rejected because it's not an exe. I was not aware of this syntax which makes lots of sense now! Very helpful, thanks!
JP

[evangelmike]

Greetings! If one does not want a DOS Window to open, one can also use ShellExecute in VBA as follows:

[code]
Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" (ByVal hWnd As Long, _
ByVal lpOperation As String, ByVal lpFile As String, _
ByVal lpParameters As String, ByVal lpDirectory As String, _
ByVal nShowCmd As Long) As Long


FileName = "C:\Documents and Settings\Michael Fitzpatrick\My Documents\Macro Scheduler" & "\SetSTEP_DELAYEnvVar.scp"
Result = ShellExecute(0&, vbNullString, FileName, vbNullString, vbNullString, vbNormalFocus)
[/code]