Is it possible to extract JUST the direct parent Folder name from the file
path and place it in a cell? (File Path here is highly variable...actual file
can be many folders deep into the path)
--
THANKS!

Steve


"Bob Phillips" wrote:

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BruceD" wrote in message
...
I understand how to enter the workbook file name into a header or footer.
Is there a way to enter the workbook file name into a worksheet cell?

Thanks