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

Syntax:

FILENAME([IncludePath])

Description:

This 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 does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current 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