Search the Community

I have a large number of QTP 11 scripts with AutoIT3 GUI front ends that report out to Excel tables I create "on-the-fly" Our company recently upgraded to Office 2010... Turns out, this is a BAD thing... for me. Now, If I save a .xls file with the following: $sOutFilePath = $TestPath & "Output\Output" & StringRight(@YEAR & @MON & @MDAY, 6) & ".xls" ;See if that exists. If so, great... use it. If not, make a new file $oExcel = _ExcelBookOpen($sOutFilePath, 0) If @error = 1 Then MsgBox(0, "Error!", "Unable to Create the Excel Object") Exit ElseIf @error = 2 Then $oExcel = _ExcelBookNew(0) ;add new header _ExcelWriteCell($oExcel, "Date&Time", 2, 1) $oExcel.Activesheet.Columns(1).ColumnWidth = 15 _ExcelWriteCell($oExcel, "Script", 2, 2) $oExcel.Activesheet.Columns(2).ColumnWidth = 55 _ExcelWriteCell($oExcel, "Iteration", 2, 3) $oExcel.Activesheet.Columns(3).ColumnWidth = 9 _ExcelWriteCell($oExcel, "Step", 2, 4) $oExcel.Activesheet.Columns(4).ColumnWidth = 5 _ExcelWriteCell($oExcel, "Pass/Fail", 2, 5) $oExcel.Activesheet.Columns(5).ColumnWidth = 9 _ExcelWriteCell($oExcel, "Notes", 2, 6) $oExcel.Activesheet.Columns(6).ColumnWidth = 85 $oExcel.ActiveWorkbook.Sheets(1).Range("A2:F2" ).Interior.Color = 0xE29F69 ;Save the new book, so it is ready to use _ExcelBookSaveAs($oExcel, $TestPath & "Output\Output" & StringRight(@YEAR & @MON & @MDAY, 6), "xls") EndIf _ExcelBookClose($oExcel, 1)all LOOKS fine... The file is created until the file is opened by QTP, where I get a compatibility popup... which hangs QTP According to THEM, I can solve this by providing .xlsx files to QTP, However, looks like all AutoIT3 can handle is: Excel writable filetype string = "xls|csv|txt|template|html", default "xls" My questions are: 1. Is there a way to work with .XLSx files in Autoit3? 2. What is the "Template" filetype ? (Excel writable filetype string = "xls|csv|txt|template|html", default "xls"