Application.DefaultWebOptions Property (Excel)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

Application.DefaultWebOptions Property (Excel)

Returns the DefaultWebOptions object that contains global application-level attributes used by Microsoft Excel whenever you save a document as a Web page or open a Web page. Read-only.

expression .DefaultWebOptions

expression A variable that represents an Application object.

This example checks to see whether the default setting for document encoding is Western, and then it sets the string strDocEncoding accordingly.

If Application.DefaultWebOptions.Encoding = msoEncodingWestern Then 
 strDocEncoding = "Western" 
Else 
 strDocEncoding = "Other" 
End If
Show:
© 2016 Microsoft