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.