Home |
Search |
Today's Posts |
#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 ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Document Properties in Header or Footer | Excel Discussion (Misc queries) | |||
Excel document properties insert into a cell | Excel Discussion (Misc queries) | |||
Help, insert a word document contents into excel tab? | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel |