| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell equal to File Name
Is there a way to put the name of the excel file in a worksheet?
Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell equal to File Name
Hi Pedro
See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Ron de Bruin http://www.rondebruin.nl "Pedro Serra" wrote in message ... Is there a way to put the name of the excel file in a worksheet? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell equal to File Name
=MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1 ))-FIND("[",CELL("filename",A1))-1)
This only works if you have saved the file at least once. "Pedro Serra" wrote: Is there a way to put the name of the excel file in a worksheet? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell equal to File Name
Thanks
"Ron de Bruin" escreveu: Hi Pedro See http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Ron de Bruin http://www.rondebruin.nl "Pedro Serra" wrote in message ... Is there a way to put the name of the excel file in a worksheet? Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell equal to File Name
Thanks
"Sloth" escreveu: =MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1 ))-FIND("[",CELL("filename",A1))-1) This only works if you have saved the file at least once. "Pedro Serra" wrote: Is there a way to put the name of the excel file in a worksheet? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| File name equal cell contents | Excel Discussion (Misc queries) | |||
| When calling a different file, can I make the tab equal to a cell? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
