Open Method

This method opens an existing workbook. The rather complex syntax is:

WorkbooksObject.Open(FileName, UpdateLinks, ReadOnly,

Format, Password, WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable, Notify, Converter, AddToMRU)

Most of these parameters are rarely used (several of them relate to opening text files, for instance). We discuss the most commonly used parameters and refer the reader to the help files for more information. Note that all of the parameters are optional except FileName.

FileName is the file name of the workbook to be opened. To open the workbook in read-only mode, set the ReadOnly parameter to True.

If a password is required to open the workbook, the Password parameter should be set to this password. If a password is required but you do not specify the password, Excel will ask for it.

The AddToMru parameter should be set to True to add this workbook to the list of recently used files. The default value is False.

0 -1

Post a comment