Share via

PublishObject Object

  • Article
Application
Aa218981.parchild(en-us,office.10).gifWorkbooks (Workbook)
Aa218981.space(en-us,office.10).gifAa218981.parchild(en-us,office.10).gifPublishObjects (PublishObject)

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 PublishObject object. The PublishObject object is a member of the PublishObjects collection.

Using the PublishObject Object

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"