Retrieves data from the database. You can specify locking behavior.
EssRetrieve([workbookName]sheetName, range, lock)
Where [workbookName]sheetName is the text name of the workbook and worksheet to which the retrieve occurs.
range is a reference to the area of data that is retrieved.
lock is a number from 1 to 3 which specifies whether the database should lock the blocks and whether the spreadsheet should be updated. The lock arguments and associated actions are shown in Table 31.
Table 31. Lock Arguments and Actions
=EssRetrieve("[Sample.xls]Sheet1", SAMPLE.XLS!A1:G20,2)