I would like to use the name of the file in the cell. How can i do that?
V Vijay Kotian Nov 9, 2006 #1 I would like to use the name of the file in the cell. How can i do that?
G Gary Rowe Nov 9, 2006 #3 =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.
=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.
C CLR Nov 9, 2006 #4 =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
=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
