| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filename in Excel Cell Address
Is there a way to insert an excel spreadsheet filename into a cell within the
same spreadsheet, like the &[File] command in the Header/Footer screen? -- Thanks, RickS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filename in Excel Cell Address
yes
=CELL("filename") -- Gary Keramidas Excel 2003 "RickS" wrote in message ... Is there a way to insert an excel spreadsheet filename into a cell within the same spreadsheet, like the &[File] command in the Header/Footer screen? -- Thanks, RickS |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filename in Excel Cell Address
Hi,
For the Fullname including path =CELL("filename") for the file name only =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1) Note the workbook must be save for this to work -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "RickS" wrote: Is there a way to insert an excel spreadsheet filename into a cell within the same spreadsheet, like the &[File] command in the Header/Footer screen? -- Thanks, RickS |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filename in Excel Cell Address
Thanks for your help Mike,
I used the ful path name and it works fine, except it also added the "Sheet1" at them end, any way not to have that? -- Thanks, RickS "Mike H" wrote: Hi, For the Fullname including path =CELL("filename") for the file name only =MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1) Note the workbook must be save for this to work -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "RickS" wrote: Is there a way to insert an excel spreadsheet filename into a cell within the same spreadsheet, like the &[File] command in the Header/Footer screen? -- Thanks, RickS |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filename in Excel Cell Address
thanks Mike,
I used the full file path approach and it is what I wanted, but it also placed the "Sheet1" at the end, is there a way to suppress this? -- Thanks, RickS "RickS" wrote: Is there a way to insert an excel spreadsheet filename into a cell within the same spreadsheet, like the &[File] command in the Header/Footer screen? -- Thanks, RickS |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filename in Excel Cell Address
thanks Gary,
is there a way to not get the "Sheet1" at the end of the path and filename? -- Thanks, RickS "Gary Keramidas" wrote: yes =CELL("filename") -- Gary Keramidas Excel 2003 "RickS" wrote in message ... Is there a way to insert an excel spreadsheet filename into a cell within the same spreadsheet, like the &[File] command in the Header/Footer screen? -- Thanks, RickS . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filename in Excel Cell Address
maybe this =LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1) -- Gary Keramidas Excel 2003 "RickS" wrote in message ... thanks Gary, is there a way to not get the "Sheet1" at the end of the path and filename? -- Thanks, RickS "Gary Keramidas" wrote: yes =CELL("filename") -- Gary Keramidas Excel 2003 "RickS" wrote in message ... Is there a way to insert an excel spreadsheet filename into a cell within the same spreadsheet, like the &[File] command in the Header/Footer screen? -- Thanks, RickS . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filename in Excel Cell Address
See the info and formula options at Bob Phillips' site.
http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 13:25:02 -0800, RickS wrote: thanks Mike, I used the full file path approach and it is what I wanted, but it also placed the "Sheet1" at the end, is there a way to suppress this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel cell address from cell contents | New Users to Excel | |||
| how to insert the path and filename into cell in excel 2002 | Excel Discussion (Misc queries) | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| Excel - print to .pdf using filename reference from cell | Excel Discussion (Misc queries) | |||
Linear Mode
