Excel copy from file to file macro not working

[alevan]

I have to copy data from multiple excel files named with numbers (1.xlsx, 2.xlsx, 3.xlsx, etc). I wrote this macro. It runs. But no copy happens, the main workbook in wich I ran the macro remains empty.

Please Login or Register  to view this content.

[Alf]

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Alf

[alevan]

Thank you. It worked.

[Alf]

You are welcome.

As this solved your problem, don't forget to mark thread "Solved"

Alf

Ps

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved