If you want to display the filename and path to a workbook in a cell you can use this
This function can also return information about the format, location and content of a
given cell. See Help in Excel for more information.
You may also use a macro to update the worksheet header/footer with the filename and
path, see Insert headers and footers for more information.