DefaultWebOptions.SaveNewWebPagesAsWebArchives property (Excel)

True if new webpages can be saved as web archives. Read/write Boolean.



expression A variable that represents a DefaultWebOptions object.


In this example, Microsoft Excel determines the settings for saving new webpages as web archives and notifies the user.

Sub DetermineSettings() 
 ' Determine settings and notify user. 
 If Application.DefaultWebOptions.SaveNewWebPagesAsWebArchives = True Then 
 MsgBox "New webpages will be saved as Web archives." 
 MsgBox "New webpages will not be saved as Web archives." 
 End If 
End Sub

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.