>I am using automation to open a text file in Excel. My intent is to have Excel open the file, do some formatting and then show the result to the user. At that point I want to release my references to Excel so that the user can do what he wants with the file. However, I find that if I close Excel while my application is still running that I still (apparently) have a reference to Excel that prevents it from shutting down completely. (Although the application does disappear from the screen, the task manager reveals that it is still running.)
>
>The code below shows whats happening...
>
>....
> Dim oExcel As Excel.Application
> Dim oWorkSheet As Excel.Worksheet
> Dim oWorkBook As Excel.Workbook
> Dim sFileName As String
>
> Set oExcel = Excel.Application
>
> 'open the temp file... activate the sheet....
> oExcel.Workbooks.Open sFileName, , , 1 'tab delimited
>
> oExcel.Workbooks(FileOf(sFileName)).Activate
> Set oWorkBook = oExcel.ActiveWorkbook
> Set oWorkSheet = oExcel.Worksheets(FileOf(sFileName, False))
>
> oWorkSheet.Columns.AutoFit
> oExcel.Goto oWorkSheet.Range("A1")
> oExcel.Visible = True
> Set oWorkSheet = Nothing
> Set oWorkBook = Nothing
> Set oExcel = Nothing
>
>SendListViewToExcel_Exit:
> Exit Sub
>
>End Sub
>
>Any suggestions?
Try this before setting oExcel = nothing:
oExcel.Quit