When closing module, does not exit visual basic editor?

[bschellingbiggs]

I have vb code that will automatically compile the application if in a non
compiled state. After recompiling, I close the module but the visual basic
editor remains open. How do I force the editor to close?

DoCmd.OpenModule "ModGlobals"
DoCmd.SelectObject acModule, "ModGlobals"
RunCommand (acCmdCompileAndSaveAllModules) 'Compile and save
DoCmd.Close acModule, "ModGlobals" 'Close module - all
but xSplash?
DoCmd.Close acModule, "form_xSplash Screen" 'Closes module but editor
open

Any ideas?

Brenda

 

[Michel Walsh]

Hi,


Won't close it, but will hide it:

VBE.MainWindow.Visible = False



Hoping it may help,
Vanderghast, Access MVP

 

[bschellingbiggs]

Thank you.

This will help while running the procedure, however, I will still need to
close the window.