I have an application I wrote that has the option to export some results to an excel sheet. The problem is that even though I close the book, I cannot open the excel file until the script exits.
The order of excel function calls (in case it helps) are as follows.
$oExcel = _ExcelBookNew(0)
_ExcelWriteSheetFromArray($oExcel,$user,1,1,0,1)
_ExcelRowInsert($oExcel,1,1)
;several _ExcelWriteCell() calls adding column names
$oExcel.ActiveSheet.Columns("A:M").AutoFit
_ExcelBookSaveAs($oExcel,