If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Document Properties
I would like to use the "WorkbookName" document property within an excel cell
(if that is the appropriate name). How do I get that name to be displayed within a cell of my worksheet? Thanks in advance, Barb Reinhardt |
#2
|
|||
|
|||
Hi Barb,
I would like to use the "WorkbookName" document property within an excel cell (if that is the appropriate name). How do I get that name to be displayed within a cell of my worksheet? path: =LEFT(CELL("filename",A1),SEARCH("\[",CELL("filename",A1))-1)&"\" filename: =MID(CELL("filename",A1),SEARCH("\[",CELL("filename",A1))+2,SEARCH("]", CELL("filename",A1))-SEARCH("\[",CELL("filename",A1))-2) I hope it is "filename", pls. see help on cell()-function. arno |
#3
|
|||
|
|||
This should help: http://www.xldynamic.com/source/xld.xlFAQ0002.html -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Barb R." wrote in message ... I would like to use the "WorkbookName" document property within an excel cell (if that is the appropriate name). How do I get that name to be displayed within a cell of my worksheet? Thanks in advance, Barb Reinhardt |
#4
|
|||
|
|||
look at the help on "Cell()"
=cell("Filename") will give you a filename including path. See if this will give you want you want "Barb R." wrote: I would like to use the "WorkbookName" document property within an excel cell (if that is the appropriate name). How do I get that name to be displayed within a cell of my worksheet? Thanks in advance, Barb Reinhardt |
#5
|
|||
|
|||
Thanks. That got me to where I could get the info I needed out of the
filename. I actually have a file name with the end date of the work week in the file name. I wanted to parse out the end date and fill it in within the spreadsheet in the appropriate places so that I didn't have to manually edit those cells. "arno" wrote: Hi Barb, I would like to use the "WorkbookName" document property within an excel cell (if that is the appropriate name). How do I get that name to be displayed within a cell of my worksheet? path: =LEFT(CELL("filename",A1),SEARCH("\[",CELL("filename",A1))-1)&"\" filename: =MID(CELL("filename",A1),SEARCH("\[",CELL("filename",A1))+2,SEARCH("]", CELL("filename",A1))-SEARCH("\[",CELL("filename",A1))-2) I hope it is "filename", pls. see help on cell()-function. arno |
#6
|
|||
|
|||
I would suggest that you always include a cell reference if you want
a correct answer See comments in italic near the top of http://www.mvps.org/dmcritchie/excel/pathname.htm various usages are then supplied to extract workbookname, worksheetname, etc. If you think it doesn't make any difference because it is all in the same workbook. That is also an incorrect assumption. Type in your crippled formula =cell("filename") then open another workbook, and hit F9, then return to your first workbook. It will have the values from the second workbook. So you would want to start with =cell("filename",A1) it doesn't matter what cell on the sheet you refer to, all you need is a reference within the sheet you want to refer to, or the workbook in this case. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "bj" wrote in message news look at the help on "Cell()" =cell("Filename") will give you a filename including path. See if this will give you want you want "Barb R." wrote: I would like to use the "WorkbookName" document property within an excel cell (if that is the appropriate name). How do I get that name to be displayed within a cell of my worksheet? Thanks in advance, Barb Reinhardt |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I edit document properties contents | Biggles | General Discussion | 2 | October 18th, 2004 07:51 PM |
Document Merge Issues | Barb Reinhardt | General Discussion | 1 | October 13th, 2004 10:59 AM |
Open File Dialogue - document properties "pop up" | Jody | General Discussion | 1 | October 7th, 2004 07:02 PM |