Returns the Excel version that was used to save the file. The latest version number is returned if several versions have been used.
Remark: The Excel version can be known:
- if the Excel file exists.
- if the Excel file is opened.
// Open an XLS file
XLSFileID = xlsOpen("C:\MyDirectory\File.XLS")
...
// Excel version
ResVersion = xlsVersion(XLSFileID)
Syntax
Syntax that is using the xlsDocument type Hide the details
<Result> = xlsVersion(<XLS document>)
<Result>: Integer
- Excel vesion (3, 4, 5, 8), 100 for the XLSX files. The latest version number is returned if several versions have been used.
- 0 if an error occurs. To get more details on the error, use xlsMsgError or ErrorInfo with the errMessage constant.
<XLS document>: xlsDocument variable
Name of the xlsDocument variable corresponding to the XLS file to use.
Syntax kept for backward compatibility with version 12 Hide the details
<Result> = xlsVersion(<XLS file identifier>)
<Result>: Integer
- Excel vesion (3, 4, 5, 8), 100 for the XLSX files. The latest version number is returned if several versions have been used.
- 0 if an error occurs. To get more details on the error, use xlsMsgError or ErrorInfo with the errMessage constant.
<XLS file identifier>: Integer
Identifier of the XLS file to handle, returned by xlsOpen.
Remarks
xlsVersion throws an error in the following cases:
- the specified XLS file is not opened.
- the Excel version in unknown.