<< Click to Display Table of Contents >> Navigation:  Macros > Macro commands and parameters > Macro input commands > Macro read from an Excel file

Similar to reporting to a Spreadsheet using Write, Read inputs data from a Spreadsheet into the Macro. Firstly the data files have to be opened and assigned. A maximum of nine data files can be opened simultaneously. After the reading operations the data files can be closed so that other data files may be opened. After execution of the Macro, all opened files will be closed automatically. Read and write operations may be executed in the same session. See:

•Open: opening a spreadsheet for Read

•Read: reading a value from a cell on the worksheet of a spreadsheet

•Close: closing a spreadsheet