|
-
Aug 17th, 1999, 10:35 PM
#1
Thread Starter
Junior Member
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?
-
Aug 18th, 1999, 04:53 AM
#2
Frenzied Member
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.
-
Aug 18th, 1999, 03:41 PM
#3
Thread Starter
Junior Member
I used
Set Excel = New Excel.Application
Excel.Workbooks.open "FileName"
-
Aug 18th, 1999, 06:21 PM
#4
Thread Starter
Junior Member
I just found the problem. I actually had forgotten to close the Excel DB in one place in the code. STUPID ME!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|