Launch a macro from a macro or a VB program

[vbdbcoder]

Hello,

What would be the best practice to launch a Sage 300 macro from another Sage 300 macro (or VB program)? The below code does not work.

*******************************************
Private Sub CommandButton1_Click()
Shell "C:\Sage\Sage300\Programs\Macros\TEST.AVB", vbNormalFocus
End Sub

Error is "Invalid procedure call or argument"


Highly Appreciated !

 

[DjangMan]

Macros are run using the a4wvba.exe program.

a4wvba.exe -r -f "filename".

However, the signon manager needs to be running. If you're running a macro then it already is. If you want to run it from a VB program then you'll need to start up the signon manager.

 

[vbdbcoder]

DjangMan,

Thanks it works.

What do the 2 parameters (-r, -f) mean?

Appreciate your help.

 

[ettienne]

-r = run
-f = file

Sage 300 Certified Consultant