I have the following formula for the current workbookname.
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1,FIND("]",CELL("filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
Please help me with a formula for its absolute path.
Thanks

Dan

Copied from Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html

File path, file and worksheet name:
=CELL("filename",A1)
File path only:
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)
File name only:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
The sheet name:
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)


Gord Dibben MS Excel MVP


On Wed, 17 Jan 2007 00:01:01 GMT, "dan" wrote:

I have the following formula for the current workbookname.
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1,FIND("]",CELL("filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
Please help me with a formula for its absolute path.
Thanks

Hi Gord
Thank you very much

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Dan

Copied from Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0002.html

File path, file and worksheet name:
=CELL("filename",A1)
File path only:
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)
File name only:
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
The sheet name:
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)


Gord Dibben MS Excel MVP


On Wed, 17 Jan 2007 00:01:01 GMT, "dan" wrote:

I have the following formula for the current workbookname.
=MID(CELL("filename",$A$1),FIND("[",CELL("filename",$A$1))+1,FIND("]",CELL("filename",$A$1))-FIND("[",CELL("filename",$A$1))-1)
Please help me with a formula for its absolute path.
Thanks