Macros: Create macro to combine several files

[GuyFromStl]

I receive daily files that I must combine into a single file each month. The data in each file is the same (fields) but the challenge is the file name is different each day.

Is there a way i can create a macro to combine all files together? Since the file names are different I would put into a temp directory and have the macro do a loop until it reads all files.

Any suggestions?

 

[GuyFromStl]

I would like to thank you for your help today. The new code worked like a charm. This will surely save time and ensure that I consolidate the data into one file without the potential for overlaying data.</SPAN>
Thanks again. </SPAN>

 

[JLGWhiz]

I would like to thank you for your help today. The new code worked like a charm. This will surely save time and ensure that I consolidate the data into one file without the potential for overlaying data.</SPAN>
Thanks again. </SPAN>

I have had better days without so much bumbling around. But I was somewhat preoccupied today and didn't pay close attention to detail. Anyhow, glad you got it going.

Regards, JLG

 

[excelbee2013]

I guess this is very common need of daily excel users. You can download this macro / Add-In to merge all files into one, if they have same headers. It works for all excel versions and let you merge any numbers of files at a time.