vba project still visible in vba-editor after closing workbook

M

mono

Dear experts,

I'm having a problem with an Excel workbook containing oledb-reference to
its own: when closing the workbook, the vba-project remains visible in the
vba editor. Before closing the workbook, the connection ist closed using e.g.
objConn.close and all objects are set to nothing. Did anybody experienced
same thing? Any solution / hints?

thanks a lot!
 

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

Similar Threads

How to show slide objects in the VBA Editor 2
VBA Editor "flashing" while Excel is still NOT Visible to the user 2
projects left open in vba after closing workbook 4
[E2007] My VBA turned into an AddIn doesn't see objects 2
Project Still Open When Workbook is Closed 2
Workbooks still appear in Project Explorer after closing in Excel? 19
VBA Project still on the list despite the Excel File closed 1
VBA (excel) quits on workbooks.open 7

Top