Use the Workbooks property of the Application object to return the Workbooks collection. The following example closes all open workbooks. Use the Add method to create a new, empty workbook and add it to the collection.
The following example adds a new, empty workbook to Microsoft Excel. Use the Open method to open a file. The picture below shows workbook "Corporate Q3. For information about linked worksheets, see the article See links between worksheets. To learn more about the features on the Inquire tab, see What you can do with Spreadsheet Inquire.
Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server. Skip to main content.
This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Workbook Interface Reference Is this page helpful? Please rate your experience Yes No. Any additional feedback? Namespace: Microsoft. Excel Assemblies: Microsoft. In this article. Gets or sets the number of minutes between automatic updates to the shared workbook. Gets or sets the number of days shown in the shared workbook's change history.
Gets or sets the way conflicts are to be resolved whenever a shared workbook is updated. Gets the collection of connections between the workbook and a data source. Gets the object that represents the container application for the workbook.
Gets a collection of properties that describe metadata that is stored in the workbook. Gets a value that indicates whether a backup file is created when this file is saved. Gets or sets a value that indicates whether the workbook uses the date system. Gets or sets a value that indicates whether ink comments are displayed in the workbook. Gets a value that indicates whether the workbook is in compatibility mode.
Gets or sets a value that indicates whether to force a full calculation of a workbook. Gets a value that indicates whether the workbook has a protection password. Gets or sets a value that indicates whether list borders are visible when a list is not active. Gets or sets a value that indicates whether the workbook is running as an add-in. Gets a value that indicates whether the specified workbook is being edited in place. Gets or sets a value that indicates whether change tracking is enabled for the shared workbook.
Gets a value that indicates whether the workbook is open as a shared list. Gets or sets the password that must be supplied to open the workbook. Gets the algorithm that Microsoft Office Excel uses to encrypt passwords for the workbook.
Gets a value that indicates whether the order of the sheets in the workbook is protected. Gets a value that indicates whether the windows of the workbook are protected. Gets a value that indicates whether the workbook has been opened as read-only.
Gets or sets a value that indicates whether the workbook was saved as read-only recommended. Gets an object that represents the research service for the workbook. Gets or sets a value that indicates whether the PivotChart Filter Pane is visible. Gets or sets a value that indicates whether the PivotTable field list can be shown. Gets or sets a value that indicates a workbook's setting for updating embedded OLE links. Gets the name of the user who currently has write permission for the workbook.
ApplyTheme String. CheckIn Object, Object, Object. Close Object, Object, Object. DeleteNumberFormat String. Assigns the current user exclusive access to the workbook that is open as a shared list. LinkSources Object. MergeWorkbook Object. OpenLinks String, Object, Object.
Post Object. PrintPreview Object. Protect Object, Object, Object. True to have Microsoft Excel not display the read-only recommended message if the workbook was saved with the Read-Only Recommended option.
If this argument is omitted, the current operating system is used. If the file is a text file and the Format argument is 6, this argument is a string that specifies the character to be used as the delimiter. For example, use Chr 9 for tabs, use "," for commas, use ";" for semicolons, or use a custom character. Only the first character of the string is used. If the file is a Microsoft Excel 4. If this argument is False or omitted, the add-in is opened as hidden, and it cannot be unhidden.
This option does not apply to add-ins created in Microsoft Excel 5. If the file is an Excel template, True to open the specified template for editing. False to open a new workbook based on the specified template. The default value is False.
Microsoft Excel will open the file as read-only, poll the file notification list, and then notify the user when the file becomes available. If this argument is False or omitted, no notification is requested, and any attempts to open an unavailable file will fail.
0コメント