Hi Barb,

I would like to use the "WorkbookName" document property within an
excel cell (if that is the appropriate name). How do I get that
name to be displayed within a cell of my worksheet?

path:
=LEFT(CELL("filename",A1),SEARCH("\[",CELL("filename",A1))-1)&"\"

filename:
=MID(CELL("filename",A1),SEARCH("\[",CELL("filename",A1))+2,SEARCH("]",
CELL("filename",A1))-SEARCH("\[",CELL("filename",A1))-2)

I hope it is "filename", pls. see help on cell()-function.

arno