<< Click to Display Table of Contents >> FILENAME (file name of the document)

Syntax:

FILENAME([IncludePath])

Description:

Returns the file name of the current document.

IncludePath (optional) determines if the path (drive and folder) should be included:

FALSE or omitted: don't include path

TRUE: include path

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

Example:

If you save a document as Balance.pmdx in folder C:\Documents:

FILENAME() returns Balance.pmdx

FILENAME(TRUE) returns C:\Documents\Balance.pmdx

See also:

USERFIELD, SHEET, SHEETNAME, CELL