ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Add path- and filenames

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


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


Erlandsen Data Consulting   
Excel & VBA Tips   Copyright ©1999-2024    Ole P. Erlandsen   All rights reserved
E-mail Contact Address