Hi Ken,
See   http://www.mvps.org/dmcritchie/excel/pathname.htm

Part 1:
  =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

Part 2:
  I presume you meant  "if I change the  content of a cell like cell A!"
  It is not very practical going the other way as you could end up with an attempt
  to name two sheets with the same name.   You would have to use macro code
  might be the line of code within a macro.
     activesheet.name = activesheet.range("A1")
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm