DefaultWebOptions Object [Excel 2003 VBA Language Reference]
Application DefaultWebOptions |
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. (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. Workbook-level attributes are contained in the WebOptions object.
Using the DefaultWebOptions Object
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.
Set objAppWebOptions = Application.DefaultWebOptions
With objAppWebOptions
If .AllowPNG = True Then
strImageFileType = "PNG"
Else
strImageFileType = "JPG"
End If
End With
Properties | AllowPNG Property | AlwaysSaveInDefaultEncoding Property | Application Property | CheckIfOfficeIsHTMLEditor Property | Creator Property | DownloadComponents Property | Encoding Property | FolderSuffix Property | Fonts Property | LoadPictures Property | LocationOfComponents Property | OrganizeInFolder Property | Parent Property | PixelsPerInch Property | RelyOnCSS Property | RelyOnVML Property | SaveHiddenData Property | SaveNewWebPagesAsWebArchives Property | ScreenSize Property | TargetBrowser Property | UpdateLinksOnSave Property | UseLongFileNames Property
Parent Objects | Application Object
Child Objects
See Also | Saving Documents as Web Pages