Close VB from Macro

K

Ken Hudson

I am using a macro to run code in a module.
I used an OpenModule action to run the module.
When I use a Close action to close the module, the program closes the module
but leaves me in the VB editor in some Event code used on some forms.
I want to close the module, exit the VB editor completely, and go back to
the database.
Can someone help here, please?
TIA.
 
K

Ken Snell \(MVP\)

One runs a VBA function by using the RunCode action. No need for the
OpenModule action. If you're wanting to run a subroutine, change it to a
function so that the RunCode action can "see" it.
 
K

Ken Hudson

Thanks, Ken.
Worked perfectly.

--
Ken Hudson


Ken Snell (MVP) said:
One runs a VBA function by using the RunCode action. No need for the
OpenModule action. If you're wanting to run a subroutine, change it to a
function so that the RunCode action can "see" it.
 

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

Top