Vba: copy a file from a directory to another directory

[Nelson78]

Hello everybody.

I have a file, suppose

paper.pdf

laying in

c:\Users\john.smith\Desktop\Folder1

I have to copy it and save in

c:\Users\john.smith\Documents


How can I figure it out?

Thank's.

 

[JLGWhiz]

Have you ever used the drag and drop feature in File Explorer? You can move files from one directory to another simply by selecting and dragging to the desired folder and releasing the mouse button. Here is a link that explains it.

How to Copy or Move Files and Folders on Windows 10 (howtogeek.com)

Unless you have a recurring need to use code to do the job, this method is fast and can move multiple files at a time.

 

[Nelson78]

I need a vba solution.

 

[JLGWhiz]

Sub t()
FileCopy "C:\Users\john.smith\desktop\Folder1\paper.pdf", "C:\Users\john.smith\Documents\paper.pdf"
End Sub