Class WebOptions (Excel VBA)

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

Class Workbook gives access to class WebOptions.

Dim wos as WebOptions
Set wos = ActiveWorkbook.WebOptions

Methods

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

Properties

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

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 webpage, 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 webpage. False if supporting files are saved in the same folder as the webpage. The default value is True.

PixelsPerInch returns or sets the density (pixels per inch) of graphics images and table cells on a webpage. 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. Microsoft Excel creates a cascading style sheet file and saves it either to the specified folder or to the same folder as your webpage, depending on the value of the OrganizeInFolder property. False if HTML tags and cascading style sheets are used. The default value is True.