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 :

=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

 

Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address