Needs macro to copy excel files from folders, subfolders to new folder

Hi to all,
I want to copy all the files from folders and subfolders to new folder and i am trying this with this macro code

Please Login or Register  to view this content.

i am getting error with this code. can any help me to solve this problem and your help will be highly aprreciated.
Thanking you
Regards,
Genetist

You didnt tell us the error, NOR where the error occured.

(usu a yellow bar will hilite the line)

Hi Ranman,

Thank you very much for your reply to my post. I am sorry for that not to mention my error here. I am getting runtime error53 and i am getting error exactly here

Please Login or Register  to view this content.

Thanks again
Regards,
Genetist

dont need the parens.
you cant copy a file to a *. You need an EXACT file name.