XLGetSheetNames

 

XLGetSheetNames>XLBookHandle,SheetsList

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Returns a semicolon delimited list of sheet names in the given workbook. XLBookHandle is a handle returned by XLCreate/XLOpen.

 

Abbreviation: XNS

See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLFind, XLGet, XLGetCell, XLGetSheetDims, XLGetSelectedCell, XLOpen, XLQuit, XLRun, XLRunCode, XLSave, XLSelectRange, XLSetCell, XLSetCellColor, XLSetRangeFormat, XLSheetToArray 

 

Example

 

XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook

XLGetSheetNames>xlBook,listSheets

Separate>listSheets,;,arrSheetNames