PublishObject Object [Excel 2003 VBA Language Reference]
Workbook PublishObjects 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"
Properties | Application Property | AutoRepublish Property | Creator Property | DivID Property | FileName Property | HtmlType Property | Parent Property | Sheet Property | Source Property | SourceType Property | Title Property
Methods | Delete Method | Publish Method
Parent Objects | Workbook
Child Objects