 |
| Selector |
|
Properties |
|
|
Files |
- |
Collection of File objects. |
|
|
Executing |
- |
Asynchronous execution flag. |
|
|
Mode |
- |
Asynchronous/synchronous operation selection. |
|
|
LogFile |
- |
Path and filename of activity log file. |
|
Methods |
|
|
Update() |
- |
Initiate extraction operation. |
|
|
LogFile |
- |
Halt synchronous extraction operation. |
|
|
Read(CriteriaFile) |
- |
Read external data selection definition file for Selector object. |
|
|
Write(CriteriaFile) |
- |
Write external data selection definition file for Selector object. |
 |
| File |
|
Properties |
|
|
Filename |
- |
Path and filename of target spreadsheet file. |
|
|
References |
- |
Collection of Reference objects. |
|
|
ErrorLog |
- |
Collection of errors encountered during data extraction. |
|
Methods |
|
|
Write(CriteriaFile) |
- |
Write external data selection definition file for File object. |
 |
| Reference |
|
Properties |
|
|
Reference |
- |
Worksheet name, range or cell reference to extract data from. |
|
|
Rows |
- |
Row range/indices of data to extract within reference. |
|
|
Columns |
- |
Column range/indices of data to extract within reference. |
|
Methods |
|
|
Value(Headings) |
- |
Returns VARIANT array of extracted cell values. |
|
|
ValueRS() |
- |
Returns ADO recordset of extracted cell values. |
|
|
Formula(Headings) |
- |
Returns VARIANT array of extracted cell formulae. |
|
|
FormulaRS() |
- |
Returns ADO recordset of extracted cell formulae. |
 |