Share via

DefaultWebOptions.Encoding Property

  • Article
Excel Developer Reference

Returns or sets the document encoding (code page or character set) to be used by the Web browser when you view the saved document. The default is the system code page. Read/write MsoEncoding.

Syntax

expression.Encoding

expression   A variable that represents a DefaultWebOptions object.

Remarks

You cannot use any of the constants that have the suffix AutoDetect. These constants are used by the ReloadAs method.

Example

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

Visual Basic for Applications 
  If Application.DefaultWebOptions.Encoding = msoEncodingWestern Then
    strDocEncoding = "Western"
Else
    strDocEncoding = "Other"
End If

See Also