Workbook Name in Cell

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
 
M

Max

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
 
S

StpNs

Try this,

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-5)
 

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

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

Top