Copying Files

[wiscokid]

I have a number of files in a folder and want to copy them all to another folder on my network.

I was going to accomplich this by opening a workbook, and within the autoopen macro have the files copied.

Does anyone know an easy way to copy all of the files from a given directory to another directory?

Thanks in Advance

Paul

 

[Norie]

Do you really need to use Excel?

Can't you just use Windows Explorer, select the files, copy them and then paste them?

 

[Barry Katcher]

Assuming you have access to the other folder, why not just use Windows Explorier?

 

[wiscokid]

There are over 30 files in 5 differnt directories which will be placed into one directory. This has to be done daily. I wanted the person who will be updating the files to have to only open an excel sheet and the rest would be taken care of.

 

[Norie]

If you really need to do this using Excel VBA then why not take a look at the FileCopy statement.

If you need more specific help then I think more information is required.