Name
workbook
.WebOptions
Synopsis
Returns the WebOptions
object for a workbook. Use the WebOptions
object to determine how a workbook is saved as a web page. The following code sets the workbook’s web options to support Internet Explorer, Version 3.0, then saves the workbook as a web page:
Dim wo As WebOptions Set wo = ThisWorkbook.WebOptions wo.TargetBrowser = msoTargetBrowserV3 ThisWorkbook.SaveAs ThisWorkbook.Path & "\new.HTML", XlFileFormat.xlHtml
Tip
Excel’s web file format features don’t work well with non-Microsoft browsers.
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.