Thread: code to strip back (from the right) a directory but not the file name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chrissie frisbee chrissie frisbee is offline
external usenet poster
  
Posts: 1
Default 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.



Reply With QuoteReply With Quote