From: "Peña, Botp" <botp@...>
Date: 2007-03-28T20:20:16+09:00
Subject: Re: excel is not closed in runtime using excel.Quit()

On Behalf Of Ruhul Amin:
# count=100
# i=0
# while i<count
# i=i+1
# begin
# excel = WIN32OLE::new('excel.Application')   # create winole Object
             ^^^^^
      put the above line of code outside of your while loop
      we'll just be opening and closing workbooks

#     workbook = excel.Workbooks.Open("#{path}") # Open the Excel file
                                    ^^^^^^^^^^^^
                     make sure this path works

#     worksheet = workbook.Worksheets(1) #get hold of the first 
# worksheet
#     worksheet.Select      # select the worksheet
#     title = worksheet.Range('h3')['Value']  #get value of title
#     excel.ActiveWorkbook.Close(0)    # close the workbook
#     excel.Quit()       #  close Excel file


     remove all the rescues first (many times they hides errors).
     let all errors go splat on the screen.

#    rescue
#      excel.Quit()
#    ensure
#      excel.Quit() unless excel.nil?
#    end
# end
#