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

T

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
 
G

Gary''s Student

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

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
 
T

ted75

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

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


ted75 said:
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
Click to expand...
Click to expand...
 
T

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

Jacob Skaria said:
'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


ted75 said:
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
Click to expand...
Click to expand...
 
T

ted75

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

Jacob Skaria said:
'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


ted75 said:
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
Click to expand...
Click to expand...
 
Top