Insert filename or filepath into Excel cell

[Anna22]

Hi

Im not sure if this is possible but i would like to be able to put a reference to the filename and/or filepath in random cells on an excel template.

I know you can put the filename into the header or footer using page setup but was wondering if there is a way of putting it into a cell.

Word has the facility by using Insert --> Field and you can select it from there, is there a samilar option in Excel.

I dont know if it makes any difference but i have Excel 2003

Regards Anna

 

[xlhelp]

=CELL("filename",A1)
give you the full path, including sheet name.

If you just want the file name but no path etc.

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

http://www.geniusmedia.ca

 

[xlbo]

Please have a look in the FAQs section before posting questions: faq68-2561

Rgds, Geoff

Well, he's kind of had it in for DPlank ever since he accidentally ran over his dog. Actually, replace "accidentally" with "repeatedly," and replace "dog" with "son."

Please read FAQ222-2244 before you ask a question