Need simple instructions on printing pathname.............ts

[ted75]

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

 

[Gary''s Student]

Just the path:
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

 

[Jacob Skaria]

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

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

If this post helps click Yes

 

[ted75]

Thanks, I was able to have my pathname displayed OK.

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

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

 

[ted75]

My first pass at your code didn't work so I need to return and work on
details a bit more.
I do not have ANY skills at creating program code to do such tasks so am a
little slow.
Thanks for your help

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

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

If this post helps click Yes
---------------
Jacob Skaria

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

 

[ted75]

Thanks Jacob, I did manage to make your scripts work for me.

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

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

If this post helps click Yes
---------------
Jacob Skaria

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