I've had to ask this question again as the administrators closed off the original question before I could test out the answer.
I'm hoping that you can repost your proposed code as that looked to be spot on.
I'm a programming noob and I am attempting to open an existing excel file with autoit, then populate specific cells with data and then closing the file with a new name.
My attempt is as follows:
#include <ExcelCOM_UDF.au3> ; Include the function collection
Local $sFilePath = "C:\Prod"
Local $sFileTempPath = "C:\Temp"
Local $File1 = "File1.xls"
Local $File2 = "File2.xls"
Local $oExcel = _ExcelBookOpen(1)
_ExcelWriteCell($oExcel, "26/11/2014", "G41") ; Write the current date to cell G41
; Now we save it into the temp directory; overwrite existing file if necessary
_ExcelBookSaveAs($oExcel, $FileTempPath & "temp.xls", "xls", 0, 1)
; And finally we close out
It compiles successfully but does not seem to do anything.
I do not get a temp file in the directory.
Thanks in advance.