Cannot save excel workbook

[karlkar]

Hello.

I am using the newest autoit and Office 2007.

In my script I have a following code:

_ExcelBookSaveAs($oExcel, $sFilePath, "xls", 1, 1)

Everything to this line works great. I create a workbook, fill it with values but finally during execution of this line I get an error:

C:\Program Files (x86)\AutoIt3\Include\Excel.au3 (356) : ==> The requested action with this object has failed.:
If $sPassword = "" And $sWritePassword = "" Then $oExcel.ActiveWorkBook.SaveAs($sFilePath, $sType, Default, Default, Default, Default, $iAccessMode, $iConflictResolution)
If $sPassword = "" And $sWritePassword = "" Then $oExcel.ActiveWorkBook^ ERROR

What is wrong? Why there is no ActiveWorkBook? should I substitute it with something else to make it work?

[water]

What's the value of $sFilePath?

[karlkar]

 

Local $sFilePath = @DesktopDir & "issue_report_" & @YEAR & "_" & @MON & "_" & @MDAY & ".xls"

[water]

Can you add a COM error handler as described in the help file for function ObjEvent?