Share via

PublishObject.Filename Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  ActiveWorkbook.PublishObjects(1).FileName = _
    "\\Server2\Q1\StockReport.htm"

See Also