Macro Scheduler 15

XLFind

XLFind>XLBookHandle,SheetName,toFind,Result

 

Not supported in Macro Scheduler Lite.

 

This function requires Microsoft Excel to be installed.

 

Finds the specified value in toFind in the given spreadsheet.  If found the cell will be activated and Result will be set to TRUE. If not found, Result will be FALSE.


Abbreviation: XLF

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

 

Example

 

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

XLFind>xlBook,Sheet1,Widgets,isFound