HtmlType Property

See Also         Example         Applies To

Returns or sets the type of HTML generated by Microsoft Excel when you save the specified item to a Web page. Can be one of the XlHtmlType constants listed in the following table, specifying whether the item is static or interactive in the Web page. The default value is xlHtmlStatic. Read/write XlHtmlType.

Constant Description
xlHtmlStatic Use static (noninteractive) HTML for viewing only.
xlHtmlCalc Use the Spreadsheet component.
xlHtmlList Use the PivotTable component.
xlHtmlChart Use the Chart component.