Macros to copy data from a different file?

[Karthik-Excelsior]

Hi,

I've around 20 files in a particular folder on my computer, and I've a template with all the macros embedded in it. Is there a way I can go to the folder choose the first file, import it or copy the contents (just the first sheet of each file has data), paste it into my template, run the in-built macros and save each of the files under a unique name either on my desktop or in some other folder (whose file path i'll specify)? This has to be a loop, as many files need to processed.

Thanks!

 

[Karthik-Excelsior]

Hi,

Any help here is much much appreciated!

Best,