after looking it up for hours, i found the answer myself in less then 5
minutes after posting this. for the records, here it is:
The Cell function returns information about the formatting, location,
or contents of the upper-left cell in a reference.
To get the sheet name:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
To get the workbook name:
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,(FIND("]",CELL("filename"))+1)-FIND("[",CELL("filename"))-2)
To get the path address & workbook name:
=CELL("filename")
To get the path address:
=MID(CELL("filename"),1,FIND("[",CELL("filename"))-1)
oh, got it from exceltip.com
--
radulucian
------------------------------------------------------------------------
radulucian's Profile:
http://www.excelforum.com/member.php...o&userid=29393
View this thread:
http://www.excelforum.com/showthread...hreadid=491042