'name of spreadsheet' function... please help
 

I am looking for a function/formulae that will return the name of the active
workbook (i.e. the name of the file I am working on). Can anybody help?

'name of spreadsheet' function... please help
 

Try

Full path and filename
=CELL("filename")

Filename only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

Mike



"TB" wrote:

I am looking for a function/formulae that will return the name of the active
workbook (i.e. the name of the file I am working on). Can anybody help?

'name of spreadsheet' function... please help
 

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

--
HTH

Bob

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

"TB" wrote in message
...
I am looking for a function/formulae that will return the name of the
active
workbook (i.e. the name of the file I am working on). Can anybody help?