Rob,

First and Foremost, thank you for helping Prema with this post. I wa
looking for a similar situation and your code helped me get over th
hump.

However, your code is easier to understand and works better than mine
(i am still learning VBA).

I have a question.

How would I set up VBA to where the user can select a directory to mov
and its new destination?

Any help is GREATLY appreciated. Thank you in advance.

SM

--
sm
-----------------------------------------------------------------------
smh's Profile: http://www.excelforum.com/member.php...fo&userid=2524
View this thread: http://www.excelforum.com/showthread.php?threadid=37800