Macro Scheduler 15

XLGet

XLGet>Filename,XLBookHandle

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Attaches to an existing running instance of Excel. If Filename is empty the first running instance of Excel will be used. Otherwise it will look for a running instance with the specified workbook open.

 

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

 

Example

 

XLGet>%USERDOCUMENTS_DIR%\mybook.xls,xlBook

XLAddSheet>xlBook,Customers

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