Is there any way to close the Visual Basic (VB) Editor using VBA coding?

[gnawoncents]

Greetings,

I have a database which uses VBA to dynamically create a report and add VB coding to the on close and on open events. All this works fine, however, when the report closes, the Visual Basic Editor remains open (it opened when the event coding was added). Is there any way to tell the VB Editor to close using coding?

I have tried programmatically closing and reopening the report, but the editor remains throughout. Any ideas?

Thanks for your help!

[slenish]

Do you have any errors that are popping up? First thing that comes to mind is you might need to put in an error handler so it checks for an error and bypasses it so it does not kick open the VB editor.

Can you post a dummy example of your DB so we can see it?

[MMcCarthy]

Try this it should close the window for you.

Application.VBE.MainWindow.Visible = False

[gnawoncents]

That did it. Thanks!