Put filename in a cell

D

DanD

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
 
C

CLR

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
 
Top