| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to ascertain path of file in adjacent directory hierarchy
For anyone interested, I have found a solution as follows:
Dim sPath as String sPath = ThisWorkbook.Path & "\..\DIR_2" Paul Martin Melbourne, Australia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Dynamic directory path | Excel Discussion (Misc queries) | |||
| auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
| How do I insert the directory path in my Excel file? | Excel Worksheet Functions | |||
| get path - save new file - same sub-directory as existing file | Excel Programming | |||
Hybrid Mode
