I want to copy a file from one folder to another with a macro. Can someone
help please?

Use the FileCopy command:


Sub CopyAFile()
Dim FromFileName As String
Dim ToFileName As String
FromFileName = "C:\Test\FileToCopy.txt"
ToFileName = "C:\Test2\FileToCopy.txt"
FileCopy Source:=FromFileName, Destination:=ToFileName
End Sub

Note that destination folder must exist, otherwise you'll get a "Path Not
Found" error. Use the MkDir function to create a new folder if necessary.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"Brettjg" wrote in message
...
I want to copy a file from one folder to another with a macro. Can someone
help please?

Thankyou Chip

"Chip Pearson" wrote:

Use the FileCopy command:


Sub CopyAFile()
Dim FromFileName As String
Dim ToFileName As String
FromFileName = "C:\Test\FileToCopy.txt"
ToFileName = "C:\Test2\FileToCopy.txt"
FileCopy Source:=FromFileName, Destination:=ToFileName
End Sub

Note that destination folder must exist, otherwise you'll get a "Path Not
Found" error. Use the MkDir function to create a new folder if necessary.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)



"Brettjg" wrote in message
...
I want to copy a file from one folder to another with a macro. Can someone
help please?