how to tag an excel file with location on drive

  • Thread starter Thread starter s
  • Start date Start date
S

s

Can I perform a function that will put, in a cell, the location of the file?

eg.

I have a file called 'ladder register'

the path to the file is
P:\work\spreadsh\registers\ladder register.xls

can i easily append this to the page so that when it is printed - one only
has to look at the footer to know where the electronic version is.
preferably in a dynamic fashion so that if the file is moved in the drive
this location data also updates.

SS
 
In Excel 2002 and onward you can set this in the file>page setup under
custom header/footer and click the
icon that looks like a folder. In earlier versions you'd need a macro.
Open the workbook in question, press Alt + F11, in the properties window to
the left find your workbook and double click ThisWorkbook and paste the
below into the main window

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftFooter = ThisWorkbook.FullName
End Sub


press Alt + Q to close the editor and save the file..
 
FILE: Page Setup... Header/Footer Tab
choose your footer from the drop down list
the entire path is one of the choices

~Teri

----- s wrote: -----

Can I perform a function that will put, in a cell, the location of the file?

eg.

I have a file called 'ladder register'

the path to the file is
P:\work\spreadsh\registers\ladder register.xls

can i easily append this to the page so that when it is printed - one only
has to look at the footer to know where the electronic version is.
preferably in a dynamic fashion so that if the file is moved in the drive
this location data also updates.

SS
 
Back
Top