Jump to content
Macro Express Forums

translation from VBA to Macro Express


Recommended Posts

Reverse to the "how launch macro express from Excel" topic:

 

I created a routine in Excel VBA and I would like to do the same in Macro Express

(when opening file, test the network user...if the user is not in the authorized people list, the programm exit).

- This sub is in a auto_open but I don't want to open the Excel file in Macro Express for executing it-

 

In stead of re-programming this, I was wondering if Macro Express can easily "translate" a sub routine written in visual basic for Excel.

If yes, how can we call this routine?

 

Thank you,

Link to comment
Share on other sites

MEP has the ability to run a script in JScript, VBScript, HTA/HTML and AutoIt. You can pass parameters and save console output. I'd recommend VBScript or (even better, but possibly a little more work) AutoIt for your requirement.

 

See Macro Control / External Script.

Link to comment
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...
 Share

×
×
  • Create New...