wilg
05-13-2011, 02:43 PM
I have this formula
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,)
which lets me know the path of my workbook up until my folder the excel workbook sits in.
Is there something similar for a formula that returns the name of a word doc that is in the folder and returns the name of that word doc in a cell in the excel worksheet?
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,)
which lets me know the path of my workbook up until my folder the excel workbook sits in.
Is there something similar for a formula that returns the name of a word doc that is in the folder and returns the name of that word doc in a cell in the excel worksheet?