VBA Open files and copy

[Jimmynowonder]

Good Afternoon,

I need to write a macro to open a series of files from a folder, copy the data from each file and paste it onto the next tab of a spreadsheet but have had no luck so far.
I have tried previously suggested VBA code but it has not worked.

Any input would be really helpful.

 

[Mentor82]

Hi,
It's essential so you provide the information what type of files you want to search within the folder, and copy their data (excel fikes, txt files etc)?

Regards,
Sebastian