"File Name" in the spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to use the File name inside tyhe spreadsheet, but I can not find how
to link it to a cell. I found that I can use it easily in footer anf header
to print out, but I need to use it as data and manage that information. Some
body know how to link the file name and set it inside the spread sheet????

Thank you!
 
Thanks Pranav, very helpful!!!
--
Albert


Pranav Vaidya said:
Hi Albert,

use CELL worksheet function as
=CELL("filename",A1)

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!
 
Back
Top