XLOpen
XLOpen>Filename,Visible,XLBookHandle[,password]
Not supported in Macro Scheduler Lite.
This function requires Microsoft Excel to be installed.
Opens an existing Excel workbook with the given filename. Set Visible to 1 to make the workbook visible, or zero to hide it. Returns a handle in XLBookHandle which should be used to reference the workbook in other XL commands.
If the workbook is password protected the password can be supplied in the password parameter to prevent the user being prompted.
Abbreviation: XLO
See also: XLAddSheet, XLCreate, XLDelCol, XLDelRow, XLDelSheet, XLFind, XLGet, XLGetCell, XLGetSheetDims, XLGetSelectedCell, XLGetSheetNames, XLQuit, XLRun, XLRunCode, XLSave, XLSelectRange, XLSetCell, XLSetCellColor, XLSetRangeFormat, XLSheetToArray
Example
XLOpen>%USERDOCUMENTS_DIR%\mybook.xls,1,xlBook
XLAddSheet>xlBook,Customers
XLSetCell>xlBook,Customers,1,1,CustID,xlRes