I am looking for help with writing a macro that will copy ALL the excel files
in a folder and paste them in another directoiry.

The files on the network in k\finance\manacs\mdr\ohd reports\

I wantto copy all the files in the OHD REPORTS folder and paste them

l \ Clyde

I have tried using record a macro but the macro is blank. Can anybody help. ?