WebOptions Object [Excel 2003 VBA Language Reference]

  • Article
Workbook
WebOptions

Contains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. 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.

Using the WebOptions Object

Use the WebOptions property to return the WebOptions object. The following example checks to see whether PNG (Portable Network Graphics) is allowed as an image format and then sets the strImageFileType variable accordingly.

Set objAppWebOptions = Workbooks(1).WebOptions
With objAppWebOptions
    If .AllowPNG = True Then
        strImageFileType = "PNG"
    Else
        strImageFileType = "JPG"
    End If
End With

Properties | AllowPNG Property | Application Property | Creator Property | DownloadComponents Property | Encoding Property | FolderSuffix Property | LocationOfComponents Property | OrganizeInFolder Property | Parent Property | PixelsPerInch Property | RelyOnCSS Property | RelyOnVML Property | ScreenSize Property | TargetBrowser Property | UseLongFileNames Property

Methods | UseDefaultFolderSuffix Method

Parent Objects | Workbook Object

Child Objects

See Also | Saving Documents as Web Pages