What's wrong with this single line of code in VBA?

[dan7055]

filecopy(CurrentPath & CSV_Files(i), MoveTo_Folder & CSV_Files(i))

When I click to go to a new line, VBA gives me a popup that says "Exepcted: ="

 

[Joe4]

What is the value of each variable, try temporarily running this line of code in its place and see what it returns:

MsgBox CurrentPath & vbCrLf & Move_To_Folder & vbCrLf & CSV_Files(i)

Make sure that each value is valid, especially making sure that your file paths are valid and have a slash on the end.
And make sure that your file name is being returned.

 

[dan7055]

What is the value of each variable, try temporarily running this line of code in its place and see what it returns:

MsgBox CurrentPath & vbCrLf & Move_To_Folder & vbCrLf & CSV_Files(i)

Make sure that each value is valid, especially making sure that your file paths are valid and have a slash on the end.
And make sure that your file name is being returned.

But that shouldn't matter though, it's giving me this error before I even run the code. It's giving me this error when I simply hit the enter button to do to writing the next line of code. It says there is a syntax error and requires and = sign. That doesn't make sense, all I want to do is copy a file from one folder to another.

 

[Joe4]

Try it without parentheses:

FileCopy CurrentPath & CSV_Files(i), MoveTo_Folder & CSV_Files(i)

It seems to like that.

 

[Domenic]

Try it without the brackets, like this...

FileCopy CurrentPath & CSV_Files(i), MoveTo_Folder & CSV_Files(i)