Copying Files Automatically Using VBA

[rraffel]

I have a series of files in one shared drive that are updated constantly. I would like to be able to automatically copy and paste these files from one drive to the next. Once they are moved I modify them all into .csv format and them they are easily imported into Access.

I cannot seem to figure out what function to use to copy and paste these files. Please help! Thx.

 

[Russell Hauf]

Try FileCopy - should be in the help files!

HTH,

Russell

 

[rraffel]

Thank you for the assistance.