Use title as cell value

[µ]

Is there a way to use the title of the spreadsheet as a cell value?
I asked this before in another topic, but there was no reply.

My sheet get's it's title from a database and is variable.
So if i can use the title i can strip several characters from the
title and use this.

So I want to retrieve the title of the spreadsheet and use this in a
cell.

Thanks!

 

[Bob Phillips]

Do you mean the sheet name?

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

See Bob Phillips' site for this.

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


Gord Dibben MS Excel MVP

 

[µ]

Thanks all of you!!
Because I'm using the Dutch version of Excel this formula looks looks
this:

=DEEL(CEL("filename");VIND.ALLES("[";CEL("filename"))+1;VIND.ALLES("]";CEL("filename"))-VIND.ALLES("[";CEL("filename"))-1)


Thanks for getting me started!!!