FileName Property

Microsoft Excel Visual Basic

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"