Nigel,

Try the following formula.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

The file must have been saved to disk in order for this to work.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nigel" wrote in message
...
hi,

can a formula retreive a worksheet name or does it need to be
macro based?


thanks,


N.S.