Show Filename in cell

Fram · May 8th, 2002, 01:53 PM

Is there a procedure to input a Filename into a cell. I want to see the filename in some cell, not in the footer/header.

Is there some function that I'm not aware of?

Thanks

Dave Patton · May 8th, 2002, 01:59 PM

Put the following in the cell where you want to show the filename.

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

Notes:
1. The file must be saved with a name.
2. The reference to a cell A1 is required.

[ This Message was edited by: Dave Patton on 2002-05-08 13:00 ]

sen_edp · May 8th, 2002, 01:59 PM

Hello

Try the cell function with infotype :"filename"

Fram · May 8th, 2002, 02:04 PM

Pretty easy, thanks!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 01:53 PM	#1
Fram New Member Join Date: May 2002 Posts: 4	Is there a procedure to input a Filename into a cell. I want to see the filename in some cell, not in the footer/header. Is there some function that I'm not aware of? Thanks

May 8th, 2002, 01:59 PM	#2
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	Put the following in the cell where you want to show the filename. =MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1) Notes: 1. The file must be saved with a name. 2. The reference to a cell A1 is required. [ This Message was edited by: Dave Patton on 2002-05-08 13:00 ]

May 8th, 2002, 01:59 PM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Hello Try the cell function with infotype :"filename"

May 8th, 2002, 02:04 PM	#4
Fram New Member Join Date: May 2002 Posts: 4	Pretty easy, thanks!!