Results 1 to 6 of 6

Thread: xl not closing

Threaded View

  1. #1

    Thread Starter
    Lively Member Bolerophone's Avatar
    Join Date
    Dec 2003
    Location
    Himalayas
    Posts
    123

    Resolved xl not closing

    I'm creating a xl worksheet i VB6 using the following code.


    Code:
    Public objXL As New Excel.Application
    Public wbXL As New Excel.Workbook
    Public wsXL As New Excel.Worksheet
    
    
        Set wbXL = Workbooks.Open(App.Path & "\test.xls") 
        Set wsXL = wbXL.Worksheets.Add(, Worksheets(1))
    i close these in this manner.


    Code:
    wbXL.Save
        Set wsXL = Nothing
        wbXL.Close False
        Set wbXL = Nothing
        Set objXL = Nothing
    After executing above code, when i open the task manager there still is an instance of xl process in memory.

    i hv win xp, vb6 SP5 , office2k. can any1 help

    -amresh-
    Last edited by Bolerophone; Nov 26th, 2004 at 01:56 AM.
    Jobs: "Do u want to sell colored sugar water or change the world?"

    Get Firefox Now!!!
    Mendhak leaving town.

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