Name
workbooks
.Open(Filename
, [UpdateLinks
], [ReadOnly
], [Format
], [Password
], [WriteResPassword
], [IgnoreReadOnlyRecommended
], [Origin
], [Delimiter
], [Editable
], [Notify
], [Converter
], [AddToMru
], [Local
], [CorruptLoad
])
Synopsis
Opens an existing workbook and adds it to the Workbooks collection . Returns a reference to the workbook that was opened.
Argument |
Settings |
---|---|
|
The file to open. |
|
One of these settings: |
|
True opens the workbook as read-only; False opens as read/write. Default is False. |
|
When opening a text file, this argument specifies the column separator character as follows: |
|
If the workbook requires a password, this is the password to open the file. The default is to prompt the user. |
|
If the workbook has a password for write access, this is the password to write to the file. The default is to prompt the user. |
|
True does not display Excel’s Read Only Recommended dialog if the file was saved with that option; False displays the prompt. Default is False. |
|
Indicates the operating system that created the file. One of the following |
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.