PublishObjects.Add procedure builder

PublishObjects.Add (Excel)

Creates an object that represents an item in a document saved to a webpage. Such objects facilitate subsequent updates to the webpage while automated changes are being made to the document in Microsoft Excel. Returns a PublishObject object.

Add (SourceType, Filename, Sheet, Source, HtmlType, DivID, Title)

With ActiveWorkbook.PublishObjects.Add(SourceType:=xlSourceRange, _ 
    Filename:="\\Server\Stockreport.htm", Sheet:="First Quarter", Source:="$G$3:$H$6", _ 
    HtmlType:=xlHtmlStatic, DivID:="Book1_4170") 
        .Publish (True) 
        .AutoRepublish = False 
End With

Arguments

The following arguments are required:

SourceType (XlSourceType) - The source type.


Possible Values are

xlSourceAutoFilter An AutoFilter range
xlSourceChart A chart
xlSourcePivotTable A PivotTable report
xlSourcePrintArea A range of cells selected for printing
xlSourceQuery A query table (external data range)
xlSourceRange A range of cells
xlSourceSheet An entire worksheet
xlSourceWorkbook A workbook

Filename (String) - The URL (on the intranet or the web) or path (local or network) to which the source object was saved.

Optional arguments

The following arguments are optional

Sheet - The name of the worksheet that was saved as a webpage

Source - A unique name used to identify items that have one of the following constants as their SourceType argument: xlSourceAutoFilter, xlSourceChart, xlSourcePivotTable, xlSourcePrintArea, xlSourceQuery, or xlSourceRange. If SourceType is xlSourceRange, Source specifies a range, which can be a defined name. If SourceType is xlSourceChart, xlSourcePivotTable, or xlSourceQuery, Source specifies the name of a chart, PivotTable report, or query table

HtmlType - Specifies whether the item is saved as an interactive Microsoft Office Web component or as static text and images. Can be one of the XlHTMLType constants: xlHtmlCalc, xlHtmlChart, xlHtmlList, or xlHtmlStatic

DivID - The unique identifier used in the HTML DIV tag to identify the item on the webpage

Title - The title of the webpage

Sheet - The name of the worksheet that was saved as a webpage

Source - A unique name used to identify items that have one of the following constants as their SourceType argument: xlSourceAutoFilter, xlSourceChart, xlSourcePivotTable, xlSourcePrintArea, xlSourceQuery, or xlSourceRange. If SourceType is xlSourceRange, Source specifies a range, which can be a defined name. If SourceType is xlSourceChart, xlSourcePivotTable, or xlSourceQuery, Source specifies the name of a chart, PivotTable report, or query table

HtmlType - Specifies whether the item is saved as an interactive Microsoft Office Web component or as static text and images. Can be one of the XlHTMLType constants: xlHtmlCalc, xlHtmlChart, xlHtmlList, or xlHtmlStatic

DivID - The unique identifier used in the HTML DIV tag to identify the item on the webpage

Title - The title of the webpage