Export (0) Print
Expand All

PublishObject.Publish Method

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



expression   A variable that represents a PublishObject object.


NameRequired/OptionalData TypeDescription
CreateOptionalVariantIf 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.


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


This example saves the range D5:D9 on the First Quarter worksheet in the active workbook to a Web page named stockreport.htm. The Spreadsheet component is used to make the Web page interactive.

Visual Basic for Applications
With ActiveWorkbook.PublishObjects.Add(xlSourceRange, _
    "\\Server1\sharedfolder\stockreport.htm", "First Quarter", _
    "$D$5:$D$9", xlHtmlStatic, "Book2_25082", "")
    .Publish (True)
    .AutoRepublish = True
End With

Community Additions

© 2014 Microsoft