EssRetrieve

Description

Retrieves data from the database. You can specify locking behavior.

Syntax

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

LockAction

1

Does not lock cells. Only a retrieve is performed. (Retrieve)

2

Locks the affected cells in the database and performs a retrieve. (Retrieve & Lock)

3

Locks the affected cells in the database but does not perform a retrieve. (Lock)

Example

=EssRetrieve("[Sample.xls]Sheet1", SAMPLE.XLS!A1:G20,2)

Notes: