Hi -

How can I replace part of the ThisWorkBook.Path property? Lucking,
the 10 characters I need to replace the END of the path (not in the
middle). To be even more specific:
THIS: \\server\drive\folder\folder\folder\DRAFT Recs
BECOMES: \\server\drive\folder\folder\folder\FINAL Recs

The "DRAFT Recs" folder itself shouldn't be re-named or deleted ...
I'm really just moving individual files from one folder to the other.
Problem is the whole path name will vary for different users ...

I would assume that the solution is to Ttrim the path by 10 characters
or to replace "DRAFT" with "FINAL" (and some of Ron deBruin's code to
re-name the file) ... but I have no idea how to do either of these?

any ideas?

thanks, ray