Add filename in a cell

[FreddieP]

Hi Is there a formula I can write in a cell in a worksheet to get it to
return the filename?

/Freddie

 

[Gary''s Student]

=CELL("filename",A1)

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Hitesh Pandya]

=CELL("filename",A1)
it is give full path in a cell