Macro Scheduler 15

XLCreate

XLCreate>Filename,Visible,XLBookHandle

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Creates a new 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.

 

Abbreviation: XLC

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

 

Example

 

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

XLAddSheet>xlBook,Customers

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

XLSave>xlBook,%USERDOCUMENTS_DIR%\mybook.xls

XLQuit>xlBook