Thread: Excel help Sheet Name...linking into Spreadsheet
View Single Post
Old 15-08-2005, 10:40   #6
Mike
Inactive
 
Join Date: Jan 2004
Age: 64
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Re: Excel help Sheet Name...linking into Spreadsheet
Quote:
Originally Posted by gazzae
Use this forumula

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,34)

Basically the =(cell("filename")) function returns - c:\data\[book1.xls]sheetname

The formula above returns whatever is after the ] ie the sheetname.
Thanks for this but just comes up with #Value!

Mike
Mike is offline   Reply With Quote