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, XLGet, XLGetCell, XLGetSheetDims, XLQuit, XLRun, XLSave, XLSetCell, XLGetSheetNames

 

Example

 

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

XLAddSheet>xlBook,Customers

XLSetCell>xlBook,Customers,1,1,CustID,xlRes