XLL+ Class Library


Opens an existing workbook

static int Open(
   const char* file_text,
   short int update_links = 0,
   bool read_only = false,
   unsigned short format = 0,
   const char* prot_pwd = 0,
   const char* write_res_pwd = 0,
   bool ignore_rorec = false,
   unsigned short file_origin = 0,
   const char* custom_delimit = 0,
   bool editable = false,
   unsigned short file_access = 0,
   bool notify_logical = false



File_text is the name, as text, of the workbook you want to open.


Update_links specifies whether and how to update external and remote references.


Read_only corresponds to the Read Only check box in the Open dialog box.


Format specifies what character to use as a delimiter when opening text files. A value of 0 is treated as a missing argument.


Prot_pwd is the password, as text, required to unprotect a protected file.


Write_res_pwd is the password, as text, required to open a read-only file with full write privileges.


Ignore_rorec is a logical value that controls whether the read-only recommended message is displayed.


File_origin is a number specifying whether a text file originated on the Macintosh or in Windows. A zero value is treated as a missing argument.


Custom_delimit is the character you want to use as a custom delimiter when opening text files.


Editable is a logical valule that corresponds to opening a file (such as a template) while holding down SHIFT key.


File_access is a number specifying how the file is to be accessed. A zero value is treated as a missing argument.


Notify_logical is a logical value that specifies whether the user should be notified when the shared document is available to be opened across a network.

Return value

Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.


See the Microsoft Excel on-line Help for full details about this function.


Header: xlfuncs.h

See Also

CXlMacros Class | CXlMacros Methods