Displaying Filename and File Path, best way to deploy to organisation Excel2K ?

  • Thread starter Thread starter bomber
  • Start date Start date
B

bomber

Hi all,

What's the best and easiest way to deploy the ability to insert the Filename
and Filepath to our organisation ?

any help would be greatly appreciated.

cheers,

Adam
 
Try a formula =CELL("filename",a1). This displays the file
name and path the next time the file is saved. Also see
help for the cell worksheet function. I don't think a1 is
critical, it just has to be a cell in the worksheet.
Hope this helps.
Paul
 
Back
Top