How to copy a .csv file from one folder to another folder with VBA?

[dan7055]

I was wondering how to do this with vba. Suppose you have the path and filename of the .csv file and you also have the path of the folder you want to move it to. What would be the syntax/code for doing this?

Thanks

 

[John_w]

Copy or move?

    FileCopy "C:\Source\Folder\File.csv", "C:\Destination\Folder\File.csv"   'Copy
    
    Name "C:\Source\Folder\File.csv" As "C:\Destination\Folder\File.csv"  'Move