Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 23rd 05, 03:22 PM
Barb R.
 
Posts: n/a
Default 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   Report Post  
Old May 23rd 05, 03:46 PM
arno
 
Posts: n/a
Default

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   Report Post  
Old May 23rd 05, 03:49 PM
RagDyeR
 
Posts: n/a
Default


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   Report Post  
Old May 23rd 05, 03:52 PM
bj
 
Posts: n/a
Default

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   Report Post  
Old May 23rd 05, 04:25 PM
Barb R.
 
Posts: n/a
Default

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   Report Post  
Old May 23rd 05, 04:55 PM
David McRitchie
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to embed Word document into Excel and retain sizing, formatti. Kent Excel Discussion (Misc queries) 0 February 2nd 05 07:37 PM
Document Properties in Header or Footer Rohullah Najafi Excel Discussion (Misc queries) 1 January 6th 05 02:59 PM
Excel document properties insert into a cell Mark Excel Discussion (Misc queries) 3 December 16th 04 02:05 PM
Help, insert a word document contents into excel tab? Dan Ward Excel Discussion (Misc queries) 2 December 15th 04 12:01 AM
Hyperlink to word document problem JS Links and Linking in Excel 0 December 8th 04 10:54 PM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017