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"