Opens an existing workbook
[C++]
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.
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