|
|
|
|
|
|
|
|
- Different errors
- Equivalent function
xlsMsgError (Function) In french: xlsMsgErreur Returns the caption of the last error caused by an XLS function.
// Open an XLS file
XLSFileID = xlsOpen("C:\MyDirectories\File.XLS")
IF XLSFileID <> -1 THEN
...
ELSE
// An error occurred in the XLS file
ResError = xlsMsgError(XLSFileID)
...
END
Syntax
Syntax that is using the xlsDocument type Hide the details
<Result> = xlsMsgError(<XLS document>)
<Result>: Character string - Caption of last error that occurred on the XLS file,
- Empty string ("") if no error occurred.
<XLS document>: xlsDocument variable Name of the xlsDocument variable corresponding to the current XLS file.
Syntax kept for backward compatibility with version 12 Hide the details
<Result> = xlsMsgError(<XLS file identifier>)
<Result>: Character string - Caption of last error that occurred on the XLS file,
- Empty string ("") if no error occurred.
<XLS file identifier>: Integer Identifier of current XLS file, returned by xlsOpen. Remarks Different errors The errors that can occur on the XLS functions are as follows: - The XLS file is not found, does not exist, is not opened, is not valid or cannot be opened.
- The specified row and/or column are empty or do not exist.
- Insufficient memory to open the file.
- The version of Excel used is unknown or too old (the XLS functions cannot read the files in Excel version 2 or earlier).
Equivalent function ErrorInfo (with the errMessage constant) also returns the details of the last error.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|