Copying a folder

[Bill T]

Hi,

I would like to be able to copy a set of folders from one
location to another using VBA. FileCopy won't do it.
Cannot find anything that will. Am I missing something?
Any suggestions appreciated.

Bill

 

[Wayne Morgan]

How about the Shell command and Dos's XCopy?

 

[Bill T.]

Wayne,

Thanks for the reply.

Yes. I am familiar with that method, but I was hoping for
something a little more sophisticated. When you shell out
to DOS commands, there is always the issue of pausing
until the DOS command completes its work.

Thanks,

Bill

 

[Wayne Morgan]

You can use FileCopy in conjunction with the Dir command. You would use the Dir command to
go through the files in the folder one at a time, passing the name to FileCopy until you
are done.