EXCEL VBA - copy file from one directory to another

Question

I get a Run-time error '52' (Bad file name or number) on the FileCopy line. The string variables seem to have the correct file location and the files open up fine when done manually. Not sure what I'm doing wrong here.

Sub copyOver()
Dim sourceFile, destFile As String
Dim fle As Variant

destFile = Sheet11.Range("A1").Value
For Each fle In Sheet11.Range("A2:A5")
    sourceFile = fle.Value
    FileCopy sourceFile, destFile
Next fle

End Sub

Tim Williams · Accepted Answer · 2017-02-09 18:19:06Z

2

You need to pass full paths (including filename) for both sourceFile and destFile

edited Feb 9, 2017 at 18:19

answered Feb 9, 2017 at 17:50

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

minnow1 Over a year ago

I did. destFile is something like C:/folder1 and sourceFile is something like C:/folder1/text.doc

cyboashu Over a year ago

C:/folder1 or C:\folder1 ? Just do a dir in your code to test if the filepath provided by you is correct.

Tim Williams Over a year ago

Full path means path and filename, not just a destination directory: updated my answer to clarify.

minnow1 Over a year ago

@cyboashu I meant C:\folder1. And it's 100% correct. I can paste the exact file path into Windows Explorer and the file opens with no problems.

minnow1 Over a year ago

@TimWilliams ahh I see what you meant. Fixed it great. Thanks!

Collectives™ on Stack Overflow

EXCEL VBA - copy file from one directory to another

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related