Edit

Share via

PublishObject.Filename property (Excel)

  • Article

Returns or sets the URL (on the intranet or the web) or the path (local or network) to the location where the specified source object was saved. Read/write String.

Syntax

expression.Filename

expression A variable that represents a PublishObject object.

Remarks

The FileName property generates an error if a folder in the specified path doesn't exist.

Example

This example sets the location where the first item in the active workbook is to be saved.

ActiveWorkbook.PublishObjects(1).FileName = _ 
 "\\Server2\Q1\StockReport.htm"

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.