| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Write cell info to external file | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
