E
EducatingMom
Is there a vba function or formual that I can use to add the file's name to
my spreadsheet?
my spreadsheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
=cell("filename")
B
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)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
E
EducatingMom
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.
spreadsheet instead of me typing in the actual filename. I want to use this
formula on several different files.
B
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
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