Publish Method

Microsoft Excel Visual Basic

Publish Method

       

Saves an item or a collection of items in a document to a Web page.

expression.Publish(Create)

expression   An expression that returns a PublishObject object or a PublishObjects collection.

Create   Optional Variant. This argument is used only with a PublishObject object. If the HTML file exists, setting this argument to True replaces the file, and setting this argument to False inserts the item or items at the end of the file. If the file does not exist, then the file is created regardless of the value of the Create argument.

Remarks

The FileName property returns or sets the location and name of the HTML file.

Example

This example saves the range D5:D9 on the First Quarter worksheet in the active workbook to a Web page called “stockreport.htm.” The Spreadsheet component is used 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