Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to insert current filename into worksheet?
Hi
I'd like to know if there is a function that I can use to put the current fileame into a cell in my worksheet? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to insert current filename into worksheet?
I just learnt this from other helpful people in this Discussion Group. It
will return the latest worksheet name to you, if change "]" to "[" and 1 to 0, then will give you file name and sheet name. See what you wants it and do a little modification. =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) This is a link they refer to, have a look/ http://www.xldynamic.com/source/xld.xlFAQ0002.html Hope it helps. "Ginko" wrote: Hi I'd like to know if there is a function that I can use to put the current fileame into a cell in my worksheet? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to insert current filename into worksheet?
And remember that without the range reference:
=CELL("filename",A1) You'll get the info from worksheet/workbook that is active when excel recalculates. Bob goes into more info at the link. Learn-more wrote: I just learnt this from other helpful people in this Discussion Group. It will return the latest worksheet name to you, if change "]" to "[" and 1 to 0, then will give you file name and sheet name. See what you wants it and do a little modification. =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) This is a link they refer to, have a look/ http://www.xldynamic.com/source/xld.xlFAQ0002.html Hope it helps. "Ginko" wrote: Hi I'd like to know if there is a function that I can use to put the current fileame into a cell in my worksheet? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't insert a worksheet into my current spreadsheet file | Excel Worksheet Functions | |||
how get filename with worksheet function? | Excel Worksheet Functions | |||
How do I insert the filename of the worksheet into a cell? | Excel Discussion (Misc queries) | |||
How do I insert the filename to a specific cell of the worksheet? | Excel Discussion (Misc queries) | |||
Function to return the current Worksheet name? | Excel Worksheet Functions |