|
|
|
|
|
|
|
|
|
|
xlsVersion (Function) In french: xlsVersion Returns the Excel version that was used to save the file. The latest version number is returned if several versions have been used. Note: The Excel version can be obtained: - if the Excel file exists.
- if the Excel file is opened.
XLSFileID = xlsOpen("C:\MyDirectory\File.XLS")
...
ResVersion = xlsVersion(XLSFileID)
Syntax
Syntax that uses 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|