|
<< Click to Display Table of Contents >> Navigation: Macros > Macro commands and parameters > Macro reporting commands > Macro write to Excel > Macrocommando Get |
Purpose:
Copying an array of cells from a workbook worksheet to an internal array.
General notation:
Get ( FileIndex , Sheet , Row1 , Column1 , Row2 , Column2 , ToArrayIndex, Row , Column )
FileIndex is the index that refers to the Excel file opened using Open.
If FileIndex is assigned the value 0, it can be copied from the workbook file described by the Macro with Write.
| Sheet | : the worksheet to be copied from. |
| Row1 | : row number of the top left corner of the range to be copied |
| Column1 | : column number of the top left corner of the series to be copied. |
| Row2 | : row number of the bottom right corner of the series to be copied |
| Column2 | : column number of the bottom right corner of the series to be copied |
ToArrayIndex : the number of the internal array
| Row | : row number of the top left corner of destination |
| Column | : column number of the top left corner of destination |