FileName Property
From Microsoft Excel Visual Basic
FileName Property
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.
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"