Template File To Open Up Various .XLS Files within the same folder

[santa12345]

Hello.
Here is what I'm trying to do.

On a monthly basis and within the same directory I could have 5, 10, maybe 20 files that need to be processed.
This number will vary....
Directory - C:\Monthly Processing
Now on a monthly basis, the files within Monthly Processing will also be named differently based on dates, customer name, etc..
Soo Lets say...this month ..the folder looks like this.
C:\Monthly Processing\10012021-Bills Hardware Store.xlsx
C:\Monthly Processing\10052021-Judys Jewerly.xlsx
etc..

I would like to create a file within the C:\Monthly Processing folder ....called 123.xlsx
Within 123.xlsx, I want to add a macro that will open up the first file (in this case, Bills Hardware Store.xlsx.....Copy Data some data from Bills Hardware Store.xlsx to the 123.xlsx file)
Save and close the Bills Hardware Store.xlsx file and then the macro within the 123.xlsx file opens up the next file ...Judys, etc.....xlsx file and performs the same steps, etc..
It continues looping until the macro has touched all the files in the C:\Monthly Processing folder, with the exception of the 123.xlsx file (of course )
Please let me know how this is doable and if you have any suggestions.
Thank you and have a nice day !

 

[Marc L]

Within 123.xlsx, I want to add a macro

Hello, as an .xlsx file can't hold any macro VBA procedure you should save it to the xlsm format or better the binary one .xlsb …​

​