Function to return the name of the document.

Posted by Chris M. on December 06, 2001 11:01 AM

I know this has been posted on here before and I have tried to look it up in the excel "help files" but I can't remember what it is. I think its =GetDocument() or something like that. Can anyone remember?

Posted by Dank on December 06, 2001 11:33 AM

Try =CELL("filename")

Posted by IML on December 06, 2001 1:45 PM

Go into Insert name define
Create a name such as Doc
in the refers to box type in
=GET.DOCUMENT(88)

Now put = doc in a cell to return the worksheet name.

I beleive this was courtesy of Mr. Pablo.

The same result can be found using
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)

good luck