I have a sheet that runs sever reports via macros, opening and closing about 6 different workbooks, saving the results on the hard drive.

Is there a way to copy the different workbooks to a different device (backup) during the macro execution? I don't want to SAVEAS, but preferably copy, so the files aren't later opened from the improper folder.

I know I could do this using a batch file to copy files, but would prefer to copy them using my macro.

TIA!