Workbook.PublishObjects Property

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.

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

See also:

• Workbook Object
• Workbook Object Members