code to strip back (from the right) a directory but not the file name
s:\jobs\2003\12345\construction\file.xls
to go up one directory use two dots.
s:\jobs\2003\12345\construction\..\file.xls
so
sPath = Thisworkbook.Path & "\..\"
sName = sPath & "file.xls"
--
Regards,
Tom Ogilvy
"chrissie frisbee" wrote in message
...
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.
|