PublishObject object (Excel)

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

Remarks

The PublishObject object is a member of the PublishObjects collection.

Example

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"

Methods

• Delete
• Publish

Properties

• Application
• AutoRepublish
• Creator
• DivID
• Filename
• HtmlType
• Parent
• Sheet
• Source
• SourceType
• Title

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.