-
I have a slight problem with my application.
When I export to my Excel 97 database through VB6, I can't open the Workbook again because VB6 never let it go. I have all the required items in the code (i.e. Excel.close False/True, Excel.Quit, and Set Excel = Nothing), but it still won't let go of the darn Excel. If I look at the task manager, it shows Excel as one of the tasks open. Can someone help me?
-
Might be a dumb question but how did you open the excel file? If, for example, you used DAO to open it, I would expect you would have to use DAO to close it.
-
I used
Set Excel = New Excel.Application
Excel.Workbooks.open "FileName"
-
I just found the problem. I actually had forgotten to close the Excel DB in one place in the code. STUPID ME!
