Put filename in a cell

[Guest]

Is there a function to put the name of the file into a cell. I can see how
to put the filename into a header or footer but I would like it in the body
of the spreadsheet

Thanks

 

[Guest]

Only works on a file that has been saved .....

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

Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

Dan

Se Bob Phillips' site for formulas.

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


Gord Dibben MS Excel MVP