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, $filePath,"xls",0,1) _ExcelBookClose($oExcel)
Now it all looks good once I close the program and open the saved file. But I'd like to be able to open the file as soon as it is saved without closing the application.
Edited by ShawnW, 16 March 2010 - 06:31 PM.