VBAProject unclosed even excel file was closed

  • Thread starter Thread starter steven
  • Start date Start date
S

steven

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 ?
 
Hi Steven,
You don't need the VBE to be open when you run your macros.
Close each module then close the VBE. You might also consider
putting subroutines together that are used together, and don't make
the modules real large because it will take longer to find and run
your macro (least that is my impression).
 
Back
Top