Southerk Posted October 10, 2019 Report Share Posted October 10, 2019 Please help!! How do I call an 'Macro Express Pro' macro from excel, when a cell is populated with a particular word/result? or, can I call the 'Macro Express Pro' macro from an 'excel' macro? Thank you in advance ;-) Quote Link to comment Share on other sites More sharing options...
Southerk Posted October 10, 2019 Author Report Share Posted October 10, 2019 sorry... I'm a newbie Quote Link to comment Share on other sites More sharing options...
Cory Posted October 10, 2019 Report Share Posted October 10, 2019 I'm not sure what you're trying to do but you can look at all the activation methods in the help file. If someone types a series of letters or numbers you can make that activate a macro. You can use a VBA macro to launch the MEP macro. Again look in the help file under Command Line Parameters. You can use the MeProc.exe with parameters that will launch a macro. 1 Quote Link to comment Share on other sites More sharing options...
Southerk Posted October 11, 2019 Author Report Share Posted October 11, 2019 Cory, Perfect!! Thanks for coming back so quickly!!! As the base excel program is fully automated and runs throughout the day, it does not require a 'user' and therefore typing to activate (shortkeys) is not suitable. I searched for 'MeProc.exe' to find the solution and used method below (ME file Test1): Sub CallMEMacro() Shell ("C:\Program Files (X86)\Macro Express Pro\MeProc.exe /ATest1") End Sub Thanks again Ken Quote Link to comment Share on other sites More sharing options...
Cory Posted November 13, 2019 Report Share Posted November 13, 2019 That was my suggestion to use VBA. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.