| XlHtmlType can be one of these XlHtmlType constants. |
| xlHtmlCalc. Use the Spreadsheet component. |
| xlHtmlChart. Use the Chart component. |
| xlHtmlList. Use the PivotTable component. |
| xlHtmlStatic. Use static (noninteractive) HTML for viewing only. |
expression.HtmlType
expression Required. An expression that returns one of the objects in the Applies To list.
Example
This example saves the range D5:D9 on the First Quarter worksheet in the active workbook to a Web page called “stockreport.htm.” You use the Spreadsheet component to add interactivity to the Web page.
ActiveWorkbook.PublishObjects.Add( _
SourceType:=xlSourceRange, _
Filename:="\\Server2\Q1\stockreport.htm", _
Sheet:="First Quarter", _
Source:="D5:D9", _
HtmlType:=xlHTMLCalc).Publish