You need to create a .vbs script file which runs VB (v similar to VBA). Why don't you create a Workbook and code the file copy in that. You can then continue with the code you need to run.