Results 1 to 4 of 4

Thread: Excel won't go away

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Posts
    20

    Post

    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?

  2. #2
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105

    Post

    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.

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Posts
    20

    Post

    I used
    Set Excel = New Excel.Application
    Excel.Workbooks.open "FileName"

  4. #4

    Thread Starter
    Junior Member
    Join Date
    Jul 1999
    Posts
    20

    Post

    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
  •  



Click Here to Expand Forum to Full Width