Trouble copying files using Call Shell

[bconner]

All,
I am experiencing difficulty in getting files to copy from selected folders to a target folder (see code below).
When I execute I don't get an error just nothing happens.
Any help is greatly appreciated.

Please Login or Register  to view this content.

[Bernie Deitrick]

Set a reference to MS Scripting Runtime, and use code like this:

Please Login or Register  to view this content.

[bconner]

Thank you Bernie you just saved me hours of frustration. If you are ever in Dallas Tx I owe you a drink sir...

[Bernie Deitrick]

Just pay it forward when you become an Excel Expert - After living in Texas for 2 years, I don't feel the need to ever return