Workbook is viewable in VBE after I close it

[Tim Zych]

I'm using ADO to grab some data from an XL workbook. After the macros run,
when I close the workbook where the code resides, I can see the workbook in
the VBE. I have closed the recordset object and set it to nothing but the
workbook properties are still visible. I can even view the code and copy it.
If I try to re-run the "closed" workbook, I get the error 429 "ActiveX
component can't create object." Typing End in the immediate window doesn't
help.

Interestingly, if I open the ADO macros workbook but don't run the macros,
then close it, the workbook closes normally with no phantom in the VBE.

Anybody know if this is related to ADO and what I can do to fix it? I have
not seen this before with other workbooks.

Thanks.

 

[onedaywhen]

Are you querying an open workbook? If so you risk going GPF:

BUG: Memory Leak Occurs When You Query an Open Excel Worksheet Using ADO
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319998

 

[Tim Zych]

Thanks. That was it. I was querying an open workbook. I've changed it so
that I only query a closed workbook and the problem is fixed.