HtmlType Property

Microsoft Excel Visual Basic

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