add file name to spreadsheet

[Guest]

Is there a vba function or formual that I can use to add the file's name to
my spreadsheet?

 

[Guest]

=cell("filename")

 

[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)

 

[Guest]

Thanks, I was looking for a formula that would put the filename into the
spreadsheet instead of me typing in the actual filename. I want to use this
formula on several different files.

 

[Beege]

Mom,

Duke gave you the actual formula, =CELL("filename") the filename inbetween
the quotes is what pulls the actual filename from the file, and will change
automatically if you "save as" and give it a new filename. Try
=CELL("filename") exactly as you see it here. (look up the CELL worksheet
function in help...)

Beege