Basically what I want to do is copy a specific file from one destination to another and then rename it.

How Is This Done??

The Name command in VBA can do both at the same time; i.e.:

Name "C:\temp\Import.txt" As "C:\data\Import.dat"

HTH

Mike