Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Put filename in a cell
Is there a function to put the name of the file into a cell. I can see how
to put the filename into a header or footer but I would like it in the body of the spreadsheet Thanks -- DanD |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Put filename in a cell
Only works on a file that has been saved .....
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-1-FIND("[",CELL("filename",A1),1)) Vaya con Dios, Chuck, CABGx3 "DanD" wrote: Is there a function to put the name of the file into a cell. I can see how to put the filename into a header or footer but I would like it in the body of the spreadsheet Thanks -- DanD |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Put filename in a cell
Dan
Se Bob Phillips' site for formulas. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Wed, 9 Aug 2006 10:42:02 -0700, DanD wrote: Is there a function to put the name of the file into a cell. I can see how to put the filename into a header or footer but I would like it in the body of the spreadsheet Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filename from a Cell | Excel Worksheet Functions | |||
substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) | |||
cell filename | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |