Execute a Module Procedure with a Macro

  • Thread starter Thread starter EA
  • Start date Start date
E

EA

Is there a way to execute a code in a module using a macro? I've used the
'OpenModule' action but it seems to only open the module instead of
executing the command.

Thanks!
 
EA -

Try the RunCode macro action, and provide the function name in your code.
Your code should be public.
 
Just to be explicit, you cannot run Subs from macros, only Functions. If
you're trying to run a Sub, change it to a Function (it doesn't matter that
it doesn't return any value)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Execute a module with a macro 1
run code from Module via a macro 6
Close VB from Macro 2
Last module in macro not completing 5
run module code from macro 2
Error Can't find procedure name 5
Outlook Private Sub Application_Startup()....What if it be public 1
Pause Macro, take action, then continue 2

Back
Top