Excel Vba To Launch Macro Express

[gernuc]

Hi,

Would anyone be able to demonstate how to activate an ME Macro from within excel VBA ( Ver 6.3 ).

I have a series of VBA macros runing within Excel, the outputs I am passing as variables to ME, I just need the automatic trigger activation to run the ME macro automatically.

I have seen the VBA example in the help file but I'm not competent enough to edit & utilise it for my task.

Any advice would be appreciated.

 

Thanks

gernuc

[Andy]

Here's vba code to run my macro called 'Current':

 

Sub CallMEMacro()

Shell ("C:\Program Files\Macro Express3\MeProc.exe /ACurrent")

End Sub