Expand Minimize

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:
© 2014 Microsoft