Jump to content
Macro Express Forums
Southerk

Activation from excel cell - or excel macro

Recommended Posts

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 ;-)

 

Share this post


Link to post
Share on other sites

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. 

  • Thanks 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...