Macro Scheduler 15

XLSave

XLSave>XLBookHandle,FileName[,fileformat]

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Saves the specified workbook to the given filename.  XLBookHandle is a handle returned by XLCreate/XLOpen.

 

To save to a different format (.e.g. to CSV or a different version of Excel) set the optional fileformat value to an xlFileFormat enumerator.

 

Abbreviation: XLS

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

 

Example

 

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

XLAddSheet>xlBook,Customers

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

XLSave>xlBook,%USERDOCUMENTS_DIR%\mybook.xls

XLQuit>xlBook