ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBE Issue (https://www.excelbanter.com/excel-programming/282176-vbe-issue.html)

Seth[_5_]

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!

Seth

Fiona[_4_]

VBE Issue
 
Sorry if this is not what your looking for but have you tried,

Ctrl-Alt & Delete, then click the offending program and End Task.


"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!

Seth



All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com