Share via

DefaultWebOptions Object

  • Article
Excel Developer Reference

Contains global application-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.

Remarks

Workbook-level attribute settings override application-level attribute settings. Workbook-level attributes are contained in the WebOptions object.

Bb223742.vs_note(en-us,office.12).gif  Note
Attribute values can be different from one workbook to another, depending on the attribute value at the time the workbook was saved.

Example

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

Visual Basic for Applications 
  Set objAppWebOptions = Application.DefaultWebOptions
With objAppWebOptions
    If .AllowPNG = True Then
        strImageFileType = "PNG"
    Else
        strImageFileType = "JPG"
    End If
End With

See Also