|
Read a Cell
Reads a cell's value from an open Microsoft Excel Document, and stores the read data into a variable for using later.
Parameters
-
Document name Specifies the document for reading.
-
Worksheet name Specifies the worksheet which contains the cell to be read.
-
Cell Specifies the cell to be read.
Read what Specifies which property of the cell to be read, it can be Value, hyperlink, formula.
-
Populate variable with result Specifies the variable to hold the read data.
-
Populate variable with state of exceeding rows Stores the number 1 into the variable if the row number
exceeds the max row in the used range, otherwise, the number 0 will be stored. You could check out the variable's value to determine
if all data have been read/written in the used range.
-
When failed to read from cell Specifies the secondary error level if gets an error during reading.
 Notes
The document must be opened by the instruction "Open Document", or be connected by the instruction "Connect an Open Document" before this step.
Microsoft Excel program must be present in the computer before playing a macro which contains this instruction.
|
