The OPEN command is used to open a specific Excel document for reading or writing.

Syntax:

Command

Keyword

Value

Developer notes

OPEN

FILE

value

Required. File path.

READONLY

*YES

Open document in read only mode.
This reduces the memory footprint as only required components are accessed from the file.

*NO

Default. Entire document is read into memory.

Example

    OPEN FILE(/folder/file.xls)

    OPEN FILE(/folder/file.xlsx)

    OPEN FILE(/folder/file.xlsx) READONLY(*YES)