PublishObject.Filename Property (Excel)
Returns or sets the URL (on the intranet or the Web) or 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"