Excel Version: 2007
I'm digging up a bit of an old issue since the only occurrence of this I can find related to the forums was back in 2009. The problem is as follows:
When using the command: _ExcelBookOpen($filepath, 0), the command _ExcelBookClose($oExcel) does not end the Excel Process and with multiple uses of _ExcelBookOpen multiple processes are opened and does not close even when the program terminates. What I want to accomplish is saving this book, closing it, ending the process without the use of "ProcessClose". If another Excel window exists, I would like it to remain open.
Things I have tried:
sleep(3000) before _excelbookclose
Updating to Beta
This was fixed by a reinstall and updating *includeExcel.au3 with http://www.autoitscript.com/forum/topic/34302-yet-another-excelcom-udf/
#include <Excel.au3> $oExcel = _ExcelBookNew(0) _ExcelWriteCell($oExcel, "Some text", 3, 2) _ExcelBookSaveAs($oExcel, @DesktopDir & "Test.xls", "xls", 0, 1) _ExcelBookClose($oExcel)
Edited by Cedri, 19 July 2012 - 04:01 PM.