Open zip folders and use data from the csv file in them

So to sketch the picture highlevel.

Lets say I have a folder in which I have 10 zip files.
All these zip files contain 1 csv file.

Now I want to loop thru all these 10 zipfiles, open them, open the csv file (comma delinited) and copy the data in a new excel sheet.
So the new excel sheet collects all the data from the csv files (the all have the same columns) that are in the zip files.

Then save the collection as 1 excel file.

Ok I now found some code (Ron de Bruin) which somewhat is what I am looking for:

Please Login or Register  to view this content.

But I rather not need to select all the files first.
(it gives an open file select box in which you manually select the files to unzip)

It needs to go just thru all the zip's it comes accros.

And I guess I always have to unzip them first to a temp folder and from there open each .csv file and then combine those into 1 xlsx file.
Or could it be done in a loop?

Apparently vba code to unzipped multiple zip files (without manually selecting them) in a folder to another folder is harder than I thought

Perhaps this link could be of interest?

https://www.get-digital-help.com/201...nd-subfolders/

At the end of the macro code there is an excel file you could down load with macro installed. Have not tested this myself so I can't tell how efficient it is but at lest it seems that you only select the folder where the zip files are stored + a folder where the extracted file should be placed and macro will do the rest.

Alf

Thanks Alf! This looks very promising.
Will need a bit tweeking to find to my needs but must be not to big of a problem

You are welcome.

Thanks for feedback and rep

Alf