R
Ray
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
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