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.
expression A variable that represents a PublishObject object.
The FileName property generates an error if a folder in the specified path doesn’t exist.
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"