workbook file name in cell

[Guest]

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

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/formulae/cell_function.html

 

[Guest]

One way

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)


Regards,

Peo Sjoblom

 

[Bob Phillips]

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

--

HTH

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

 

[Guest]

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)