Description: Gets the names of the sheets specified.
Parameters:
GetSheetNames(spath As String, sSheets As String, sSheetNames() As String)
|
Parameter |
Meaning |
|
sPath |
Original Excel file |
|
sSheets |
Selected sheets. May be specified as "*", or "1", or "1-3,10,12". |
|
sSheetNames |
Array storing selected sheets. |
Return Values:
>= 0: Number of sheets found
-3: Cannot create Excel object
-11: Invalid sheet specified (empty string)
-202: Original file does not exist