Add path- and filenames

 2000-02-04    Printing    0    43

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.


Leave a comment:

Your comment will only be published after it has been moderated and found spam free.
Your e-mail address will only be used to display your Gravatar.