VBA, Copy folder using FileSystemObject

[CROY1985]

Hi all

I need a macro which will copy a folder from one location to another.

I have added "Microsoft Scripting Runtime" to my reference library, and have the following code:

FileSystemObject.CopyFolder "C:\Users\accsercw\Desktop\210 - Exception Reporting\Final Reports\2235", "C:\Users\accsercw\Desktop\210 - Exception Reporting\Final Reports2\"

I get an "object required" error message.

Can anyone point me in the right direction?

Thank you

 

[John_w]

    Dim FSO As Scripting.FileSystemObject
    Set FSO = New Scripting.FileSystemObject
    FSO.CopyFolder "C:\Users\accsercw\Desktop\210 - Exception Reporting\Final Reports\2235", "C:\Users\accsercw\Desktop\210 - Exception Reporting\Final Reports2\"

 

[CROY1985]

Thank you!