Share via

PublishObject.AutoRepublish Property

  • Article
Excel Developer Reference

When a workbook is saved, Microsoft Excel determines if any item in the PublishObjects collection has the AutoRepublish property set to True and, if so, republishes it. The default value is False. Read/write Boolean.

Syntax

expression.AutoRepublish

expression   A variable that represents a PublishObject object.

Example

This example publishes a range on a worksheet to an HTML file on the C: drive. When the user saves the workbook containing the worksheet, Excel will automatically republish the range to the same HTML file. This example assumes that the user has read/write access to the web page and that cells A1 through D10 in the worksheet have values in them.

Visual Basic for Applications 
  Sub PublishToWeb()

With ActiveWorkbook.PublishObjects.Add( _
    SourceType:= xlSourceRange, _
    Filename:="C:\Work.htm", _
    Sheet:="Sheet1", _
    Source:="A1:D10", _
    HtmlType:=xlHtmlStatic, _
    DivID:="Book1.xls_130489")
    .Publish
    .<strong>AutoRepublish</strong> = True
End With



End Sub

See Also