5 4 3 OPEN

You are here:

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.
	READONLY	*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)