_Excel_BookSaveAs

[JohnOne]

Below is a quote from the helpfile.

 

 

Starting with Excel 2007 you have to provide both the $iFormat parameter and the correct file extension in $sFilePath.

 

My question is, how do I know what extension a user will need?

For example I have excel version 15 as reported by.

$oExcel.Version

But what version is pre 2007, does the number correspond to the year, for instance if I had excel 2006, would the above code produce 6?

EDIT:

Because I'd like to use $xlWorkbookDefault " Workbook default (.xls for < Excel 2007, .xlsx for > Excel 2007)"

Edited February 23, 2015 by JohnOne

[water]

The versions of Excel can be found here.

[JohnOne]

Thanks, so would you say this will suffice?

Local $ext = "xls"
If $oAppl.Version >= 12 Then
    $ext = "xlsx"
EndIf
_Excel_BookSaveAs($oWorkbook, @ScriptDir & "\catalog." & $ext, $xlWorkbookDefault)

[water]

If the content of the workbook doesn't change based on the used Excel version, then I would always save it as XLS. All Excels versions understand the XLS file format. No need to create XLSX files for newer versions.

[JohnOne]

In my search for the difference, I read that .xls is more likely to become corrupted and the files are larger.

[water]

Never had a problem with XLS files.

XLS files are in a binary format whereas XLSX files are ZIP-compressed XML files.

I suggest to use XLS.

Edited February 23, 2015 by water

[JohnOne]

Ok, thanks for the advice, I'll take it graciously.