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.
Syntax
expression .DefaultWebOptions
expression A variable that represents an Application object.
Example
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