> I use a ASP-file to put a variable ia an Excel-sheet let the Excel-sheet
> do its trick and get the resulting variable.
> This works fine on the server. Only the instance of Excel will not
> close. So I'm getting a lot of Excel-instances and the files opened by
> them can't be modified or deleted.
> I need to close Excel after I've got the resulting variable.
> Here's the code:

>  Set xlApplication = Server.CreateObject("Excel.Application")
>  ' Open str_newFile
>  xlApplication.Workbooks.Open str_newFile
>  Set xlWorksheet = xlApplication.WorkSheets(1)
>  xlWorksheet.Range("a1") = 1
>  response.write (xlWorksheet.Range("a11"))
>  xlApplication.Quit 'Close the Workbook
>  Set xlWorksheet = Nothing
>  Set xlApplication = Nothing

> Why isn't Excel released from memory????

> Thanks in advanced

> Paul

> --
> **************************
> Snow is just frozen water!
> meems.cjb.net
> **************************

> Sent via Deja.com http://www.deja.com/
> Before you buy.

> I use a ASP-file to put a variable ia an Excel-sheet let the Excel-
sheet
> do its trick and get the resulting variable.
> This works fine on the server. Only the instance of Excel will not
> close. So I'm getting a lot of Excel-instances and the files opened by
> them can't be modified or deleted.
> I need to close Excel after I've got the resulting variable.
> Here's the code:

>  Set xlApplication = Server.CreateObject("Excel.Application")
>  ' Open str_newFile
>  xlApplication.Workbooks.Open str_newFile
>  Set xlWorksheet = xlApplication.WorkSheets(1)
>  xlWorksheet.Range("a1") = 1
>  response.write (xlWorksheet.Range("a11"))
>  xlApplication.Quit 'Close the Workbook
>  Set xlWorksheet = Nothing
>  Set xlApplication = Nothing

> Why isn't Excel released from memory????

> Thanks in advanced

> Paul