How to pick up file name in the cell
 

I would like to use the name of the file in the cell. How can i do that?

How to pick up file name in the cell
 

=CELL("filename",A1) will even supply you with the path as well.
--
Gary's Student


"Vijay Kotian" wrote:

I would like to use the name of the file in the cell. How can i do that?

How to pick up file name in the cell
 

=cell("filename", A1) returns the filename (including full path) of the file
that contains reference, as text. Returns empty text ("") if the worksheet
that contains reference has not yet been saved.

"Vijay Kotian" wrote:

I would like to use the name of the file in the cell. How can i do that?

How to pick up file name in the cell
 

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

Workbook must be saved once first........

Vaya con Dios,
Chuck, CABGx3




"Vijay Kotian" wrote:

I would like to use the name of the file in the cell. How can i do that?