Workbook need to be saved

=SUBSTITUTE(MID(CELL("filename",B1),FIND("[",CELL("filename",B1))+1,255),"]"&MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32),"")


for sheet


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



for path/name/sheet

=CELL("Filename",A1)

--
Regards,

Peo Sjoblom

(No private emails please)


"mikeburg" wrote in
message ...

Is there a formula that obtains the workbook name that I can put in cell
A1?

Also,

Is there a formula that obtains the worksheet name that I can put in
cell A2?

Thanks so very much. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=482983