WebOptions Interface

Definition

Contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.

public interface class WebOptions
[System.Runtime.InteropServices.Guid("00024449-0000-0000-C000-000000000046")]
public interface WebOptions
Public Interface WebOptions
Attributes

Remarks

You can return or set attributes either at the application (global) level or at the workbook level. (Note that attribute values can be different from one workbook to another, depending on the attribute value at the time the workbook was saved.) Workbook-level attribute settings override application-level attribute settings. Application-level attributes are contained in the DefaultWebOptions object.

Use the WebOptions property to return the WebOptions object.

Properties

AllowPNG

True if PNG (Portable Network Graphics) is allowed as an image format when you save documents as a Web page. False if PNG is not allowed as an output format. The default value is False.

Application

Returns an Application object that represents the Microsoft Excel application.

Creator

Returns a 32-bit integer that indicates the application in which this object was created.

DownloadComponents

True if the necessary Microsoft Office Web components are downloaded when you view the saved document in a Web browser, but only if the components are not already installed. False if the components are not downloaded. The default value is False.

Encoding

Returns or sets the document encoding (code page or character set) to be used by the Web browser when you view the saved document. The default is the system code page.

FolderSuffix

Returns the folder suffix that Microsoft Excel uses when you save a document as a Web page, use long file names, and choose to save supporting files in a separate folder (that is, if the UseLongFileNames and OrganizeInFolder properties are set to True).

LocationOfComponents

Returns or sets the central URL (on the intranet or Web) or path (local or network) to the location from which authorized users can download Microsoft Office Web components when viewing your saved document. The default value is the local or network installation path for Microsoft Office.

OrganizeInFolder

True if all supporting files, such as background textures and graphics, are organized in a separate folder when you save the specified document as a Web page. False if supporting files are saved in the same folder as the Web page. The default value is True.

Parent

Returns the parent object for the specified object.

PixelsPerInch

Returns or sets the density (pixels per inch) of graphics images and table cells on a Web page. The range of settings is usually from 19 to 480, and common settings for popular screen sizes are 72, 96, and 120. The default setting is 96.

RelyOnCSS

True if cascading style sheets (CSS) are used for font formatting when you view a saved document in a Web browser. False if HTML <FONT> tags and cascading style sheets are used. The default value is True.

RelyOnVML

True if image files are not generated from drawing objects when you save a document as a Web page. False if images are generated. The default value is False.

ScreenSize

Returns or sets an MsoScreenSize constant specifying the ideal minimum screen size (width by height, in pixels) that you should use when viewing the saved document in a Web browser. The default constant is msoScreenSize800x600.

TargetBrowser

Returns or sets an MsoTargetBrowser constant indicating the browser version.

UseLongFileNames

True if long file names are used when you save the document as a Web page. False if long file names are not used and the DOS file name format (8.3) is used. The default value is True.

Methods

UseDefaultFolderSuffix()

Sets the folder suffix for the specified document to the default suffix for the language support you have selected or installed.

Applies to