PublishObjects Object

Remarks

Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object.

Example

Use the PublishObjects property to return the PublishObjects collection. The following example saves 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

Use PublishObjects(), where is the index number of the specified item in the workbook, to return a single PublishObjectobject. The following example sets the location where the first item in workbook three is saved.

Workbooks(3).PublishObjects(1).FileName = _ "\\myserver\public\finacct\statemnt.htm"

See also:

• Excel Object Model Reference
• PublishObjects Object Members
• Saving Documents as Web Pages