Copy one range from multiple files.

[Tom Jones]

Hello,

I have a folder with 40 to 90 files. Each file has the same data structure. I want to copy the range A8: Z8 of each file in my file where launch VBA code, starting with A10. Can anyone help me?

Thank you.

[alansidman]

This should get you started.

https://support.microsoft.com/en-us/kb/139724

[Tom Jones]

Thank you alansidman,

Before asking for help I have studied several VBA codes in internet and found some. But it lasts very long.
If you can help with faster code as well.

[alansidman]

What have you used that you find slow. Post an example of working code that you wish to speed up.