April 2006
Beginner
1114 pages
98h 16m
English
workbook.WebOptions
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
Excel’s web file format features don’t work well with non-Microsoft browsers.
Read now
Unlock full access