Add path- and filenames

If you want to display the filename and path to a workbook in a cell you can use this function :

=CELL("filename")

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.

Document last updated 2000-02-04 12:45:07 Printerfriendly version