"File Name" in the spreadsheet

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!
 
G

Guest

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top