PublishObjects Object (Excel)
A collection of all PublishObject objects in the workbook.
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.
Set objPObjs = ActiveWorkbook.PublishObjects For Each objPO in objPObjs If objPO.HtmlType = xlHTMLStatic Then objPO.Publish End If Next objPO
Use PublishObjects(index), where index is the index number of the specified item in the workbook, to return a single PublishObject object. 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"