| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject unclosed even excel file was closed
I need to use some worksheets in the current workbook as datasources and run some queries.
The code to connect the workbook is just like below Set dbs = OpenDatabase(ThisWorkbook.Path & "\" & ThisWorkbook.Name, dbDriverCompleteRequired, True, _ "Excel 8.0;") strSQL = "SELECT .... " Set rs = dbs.OpenRecordset(strSQL) But I found that the VBAProject keep unclosed even the excel file was closed after running queries. Also, the performance seems dropped after running queries serveral times. Anyone know why ? Any problem with my code ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I closed an excel file without saving the changes. Can I retrieve | Excel Discussion (Misc queries) | |||
| How to recover excel file that was closed without saving? | Excel Discussion (Misc queries) | |||
| VBAProject remains open after file is closed | Excel Discussion (Misc queries) | |||
| How can I add values to a closed excel file? | Excel Worksheet Functions | |||
| Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
![steven[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
