DefaultWebOptions.SaveNewWebPagesAsWebArchives Property (Excel)
True if new Web pages can be saved as Web archives. Read/write Boolean.
Syntax
expression .SaveNewWebPagesAsWebArchives
expression A variable that represents a DefaultWebOptions object.
Example
In this example, Microsoft Excel determines the settings for saving new Web pages as Web archives and notifies the user.
Sub DetermineSettings()
' Determine settings and notify user.
If Application.DefaultWebOptions.SaveNewWebPagesAsWebArchives = True Then
MsgBox "New Web pages will be saved as Web archives."
Else
MsgBox "New Web pages will not be saved as Web archives."
End If
End Sub