PDA

Click to See Complete Forum and Search --> : Excel won't go away


ChrisCote
Aug 17th, 1999, 10:35 PM
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?

JHausmann
Aug 18th, 1999, 04:53 AM
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.

ChrisCote
Aug 18th, 1999, 03:41 PM
I used
Set Excel = New Excel.Application
Excel.Workbooks.open "FileName"

ChrisCote
Aug 18th, 1999, 06:21 PM
I just found the problem. I actually had forgotten to close the Excel DB in one place in the code. STUPID ME!