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

--

HTH

Bob Phillips

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

"EducatingMom" wrote in message
...
Is there a vba function or formual that I can use to add the file's name
to
my spreadsheet?