Error using VBA FileCopy Function

**AnthonyWB** · 07-20-2010, 02:05 PM

I am recieving an error in the following code

FileCopy ""fPath" & fPriorDate & "_157\" & "157_Reports\IBRD_Disclosure\157_Disclosure"", ""fPath & fDate & "_157\" & "157_Reports\IBRD_Disclosure\157_Disclosure""

I would like to copy a specific file from one folder to another. fPath, fDate, and fPriorDate have all been declared globally. Any suggestions

**shg** · 07-20-2010, 02:10 PM

Form the two strings into variables, print them to the debug window, and verify that they are correct.

**AnthonyWB** · 07-20-2010, 02:22 PM

I am assuming you mean intermediate window?

? "fPath" & fPriorDate & "_157\" & "157_Reports\IBRD_Disclosure\157_Disclosure"
fPath31-May-2010_157\157_Reports\IBRD_Disclosure\157_Disclosure
?"fPath & fDate & "_157\" & "157_Reports\IBRD_Disclosure\157_Disclosure"

Invalid Character. So the mistake is in the second part.

**AnthonyWB** · 07-20-2010, 02:31 PM

I think I got it.

**shg** · 07-20-2010, 03:03 PM

What I meant was

    Dim sCopyFr As String
    Dim sCopyTo As String
    
    sCopyFr = fPath & fPriorDate & "_157\157_Reports\IBRD_Disclosure\157_Disclosure"
    sCopyTo = fPath & fDate & "_157\157_Reports\IBRD_Disclosure\157_Disclosure"
    Debug.Print sCopyFr & vbLf & sCopyTo
    
    FileCopy sCopyFr, sCopyTo

... but all roads lead to Rome.