Put filename in a cell
 

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
--
DanD

Put filename in a cell
 

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



"DanD" wrote:

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
--
DanD

Put filename in a cell
 

Dan

Se Bob Phillips' site for formulas.

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


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 10:42:02 -0700, DanD wrote:

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