Read Multiple Cells
Reads multiple cells from an open Microsoft Excel Document, and stores the read data into an array.
Document name Specifies the document for reading.
Worksheet name Specifies the worksheet which contains the cell to be read.
Columns Specifies the columns to be read.
Rows Specifies the rows 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 name of the variable that will store 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.
- Re-define the variable is not necessary. The variable will be converted to an array automatically.
- 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.