Just the path:
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)
--
Gary''s Student - gsnu200856


"ted75" wrote:

I'm NOT a skilled Excel user so other posts here on same subject aren't
detailed enough to help me. I run Excel 2002 , NOT system 7

I want to auto enter my workbook's complete pathname into a cell.


Thanks much, ted