| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need simple instructions on printing pathname.............ts
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need simple instructions on printing pathname.............ts
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need simple instructions on printing pathname.............ts
'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" 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need simple instructions on printing pathname.............ts
Thanks, I was able to have my pathname displayed OK.
"Gary''s Student" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need simple instructions on printing pathname.............ts
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" wrote: '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" 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need simple instructions on printing pathname.............ts
Thanks Jacob, I did manage to make your scripts work for me.
"Jacob Skaria" wrote: '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" 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup dynamic pathname | Excel Discussion (Misc queries) | |||
| How do I display the pathname/address of a hyperlink? | Excel Worksheet Functions | |||
| Using a dynamic pathname in VLOOKUP | Excel Worksheet Functions | |||
| Using a variable to represent the pathname in a formula | Excel Discussion (Misc queries) | |||
| Full Pathname in Titlebar | Setting up and Configuration of Excel | |||
Linear Mode
