Insert file name into Cell

[Bonny]

Is there a way to insert the file name into a cell, rather than on
header/footer?

 

[David McRitchie]

Hi Bonny,

1996FEDT.XLS

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

D:\driveM\excel\TAXES\1996FEDT.XLS [Sheet1]
=SUBSTITUTE(SUBSTITUTE(CELL("filename",A1),"[",""),"]"," [") & "]"

for more information, worksheet examples, and coding examples for
pathname, filename, sheetname and combinations of such see
http://www.mvps.org/dmcritchie/excel/pathname.htm

 

[Bob Phillips]

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0002.html

--

HTH

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

 

[Gord Dibben]

Bonny

See Bob Phillips' site for worksheet formula.

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


Gord Dibben Excel MVP