Prev: How do I alphabetize the tabs on a spreadsheet with 25 tabs?
Next: IF AND VLOOKUP formula needed
From: Mike H on 27 May 2010 16:51 Hi, Put this formula in a cell. It only works if the workbook has been saved =MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "SeeThomas" wrote: > Is there a way to automatically paste the file name of an open excel file > into one of its own cells. I can paste the file name of a Word Document with > a couple of easy steps into a Word document but cannot find a way to do so in > Excel. > Thanks > SeeThomas
From: Mike H on 27 May 2010 18:01 I should have added if you want the full path and filename use =CELL("filename") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mike H" wrote: > Hi, > > Put this formula in a cell. It only works if the workbook has been saved > > =MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) > > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "SeeThomas" wrote: > > > Is there a way to automatically paste the file name of an open excel file > > into one of its own cells. I can paste the file name of a Word Document with > > a couple of easy steps into a Word document but cannot find a way to do so in > > Excel. > > Thanks > > SeeThomas
From: Dave Peterson on 27 May 2010 20:11 I'd include a reference to a cell in that worksheet: =CELL("filename",a1) (I use the address of the cell that contains the formula) Otherwise, when excel recalculates, you'll see the names of the activesheet and the activeworkbook. Mike H wrote: > > I should have added if you want the full path and filename use > > =CELL("filename") > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > "Mike H" wrote: > > > Hi, > > > > Put this formula in a cell. It only works if the workbook has been saved > > > > =MID(CELL("filename",A1),1+FIND("[",CELL("filename",A1)),FIND(".",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1) > > > > -- > > Mike > > > > When competing hypotheses are otherwise equal, adopt the hypothesis that > > introduces the fewest assumptions while still sufficiently answering the > > question. > > > > > > "SeeThomas" wrote: > > > > > Is there a way to automatically paste the file name of an open excel file > > > into one of its own cells. I can paste the file name of a Word Document with > > > a couple of easy steps into a Word document but cannot find a way to do so in > > > Excel. > > > Thanks > > > SeeThomas -- Dave Peterson
|
Pages: 1 Prev: How do I alphabetize the tabs on a spreadsheet with 25 tabs? Next: IF AND VLOOKUP formula needed |