Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum issue | Excel Worksheet Functions | |||
Issue | Excel Discussion (Misc queries) | |||
Different day, different IF issue | Excel Discussion (Misc queries) | |||
IIF issue | Excel Worksheet Functions | |||
DV Issue | Excel Worksheet Functions |