How to display the current directory for existing worksheet?

[Eric]

Does anyone have any suggestions on how to display the current directory for
existing worksheet in cell A1?
Thanks in advance for any suggestions
Eric

 

[David Biddulph]

=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1))-1)