Workbook.PublishObjects Property

  • Article
Excel Developer Reference

Returns the PublishObjects collection. Read-only.

Syntax

expression.PublishObjects

expression   A variable that represents a Workbook object.

Example

This example publishes all static PublishObject objects in the active workbook to the Web page.

Visual Basic for Applications 
  Set objPObjs = ActiveWorkbook.PublishObjects
For Each objPO in objPObjs
    If objPO.HtmlType = xlHTMLStatic Then
        objPO.Publish
    End If
Next objPO

See Also