| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to strip back (from the right) a directory but not the file name
I have a path
eg. s:\jobs\2003\12345\construction\file.xls I want to find the code that strips a level of this path out i.e. remove \construction. (Go up a directory) eg. s:\jobs\2003\12345\file.xls This is so my destination file can be automatically relinked to a source file that is kept in the directory above the current destination files directory. Thank you very much Chrissie. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strip Flat File Table into less entries | Excel Worksheet Functions | |||
| VB Code for a directory | Excel Discussion (Misc queries) | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| Code to raise Directory request box | Excel Worksheet Functions | |||
| How do I strip a XML file to Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
