Opens an existing workbook
static int Open( LPCTSTR file_text, short int update_links = 0, bool read_only = false, unsigned short format = 0, LPCTSTR prot_pwd = 0, LPCTSTR write_res_pwd = 0, bool ignore_rorec = false, unsigned short file_origin = 0, LPCTSTR 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