VBE Issue
 

I am running a program that uses the ADO object and SQL
to retrieve data from a table. When I execute the
procedure to retrieve the data (opening the connection,
etc.) I get a problem: There is a dulpicate version of
the workbook in the VBE. When I close the workbook,
there is still a VBE project with the same name just
sitting there.

1. What is causing this?

and, more importantly,

2. Does anyone know how to stop this from happening, or
unloading the duplicate project?

Thanks!

VBE Issue
 

Seth

When you close which workbook? Post the code that you are using. Make sure
you are closing the ADODB.Connection object.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Seth" wrote in message
...
I am running a program that uses the ADO object and SQL
to retrieve data from a table. When I execute the
procedure to retrieve the data (opening the connection,
etc.) I get a problem: There is a dulpicate version of
the workbook in the VBE. When I close the workbook,
there is still a VBE project with the same name just
sitting there.

1. What is causing this?

and, more importantly,

2. Does anyone know how to stop this from happening, or
unloading the duplicate project?

Thanks!