Question: how to copy files from one folder to another using vba?
Answer: Declaring Variables. The first piece of code we need to write is a DIM statement. ... 
Setting The Source File. The next step in the macro is to set the source file. ... 
Setting The Destination File. Next, we set the destination of where we want to copy the file to. ... 
Copy The File. ... 
Ending The Macro.