Macro Scheduler 15

XLDelCol

XLDelCol>XLBookHandle,SheetName,Col

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Deletes the specified column in the given workbook and sheet name.  Requires a column range name. E.g. "A:A" for column A.

 

XLBookHandle is a handle returned by XLCreate/XLOpen.

 

Abbreviation: XDC

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


Example

 

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

XLDelCol>xlBook,Sheet1,D:D

XLSave>xlBook,%USERDOCUMENTS_DIR%\mybook.xls

XLQuit>xlBook