DefaultWebOptions object (Excel)
Contains global application-level attributes used by Microsoft Excel when you save a document as a webpage or open a webpage. 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.
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 of the Application object 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.
Set objAppWebOptions = Application.DefaultWebOptions
With objAppWebOptions
If .AllowPNG = True Then
strImageFileType = "PNG"
Else
strImageFileType = "JPG"
End If
End With
Properties
- AllowPNG
- AlwaysSaveInDefaultEncoding
- Application
- CheckIfOfficeIsHTMLEditor
- Creator
- DownloadComponents
- Encoding
- FolderSuffix
- Fonts
- LoadPictures
- LocationOfComponents
- OrganizeInFolder
- Parent
- PixelsPerInch
- RelyOnCSS
- RelyOnVML
- SaveHiddenData
- SaveNewWebPagesAsWebArchives
- ScreenSize
- TargetBrowser
- UpdateLinksOnSave
- UseLongFileNames
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.