Visual Basic Window 1

[hickeyc]

I have some VBA code that opens a module and then later closes it. The module closes but the Visual Basic Window remains open. Is there any way to close this window using VBA code?

 

[Sawatzky]

dear hickeyc,

Couldn't you let the module close the window?

regards Astrid

 

[hickeyc]

I'm closing the module using this command:

DoCmd.Close acModule, "Name Public Variables", acSaveYes

It closes this module but leaves the VBA window open. Is there another way to close the module?

 

[Sawatzky]

dear hickeyc,

what about this?

Application.VBE.MainWindow.Close

Give it a try and tell me

regards
Astrid

 

[hickeyc]

That gives me a system error, closes the access database, still leaves the VBA window open.

I also tried using activewindow in place of mainwindow with the same results.

Thank you for the suggestion. I appreciate your time and help on this.

 

[ide]

try
Application.VBE.MainWindow.Visible = False

ide

 

[hickeyc]

That seems to be working. Thank you!