Workbook Name in Cell

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

RoadKill

I found that you can do a sheet name to display in a cell, but can you do the
same with the workbook name?

For example, if the workbook is named Jabroni Johnson.xls then cell A1 of
Sheet1 in that workbook should also display Jabroni Johnson.

Thank you
 
With the book saved beforehand
In any cell, in any sheet
=TRIM(SUBSTITUTE(MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1),".xls",""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
 
Try this,

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-5)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Using names referencing a cell in another workbook 2
Referencing Workbook Name in Formula 3
Referencing another workbook using a variable for the sheet? 20
Reference to a Defined Name in another Workbook 1
Cell highlighting question 4
Set non-continuous PrintArea via Function / Name 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top