Close VB from Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Back
Top