Execute Excel Macro Repeatedly for all csv files in a folder

[Zachary69]

Hi everyone,

Every week I will have to download about 600 csv files containing data from different sensors. Currently, for each of this csv files I have written a macro to do analysis and it generally takes less then 10 seconds for each one. I have written the macro such that at the end of the execution the result (in one row) will be pre copied, then I would have to paste it in another master listing manually and lastly I will go back to the analysis macro file and clear the existing query (with a simple macro I wrote). I will repeat this process for another 599 times.

I have very little experience in coding, but having that analysis macro was a small achievement for me. So I would like to ask if it is possible for me to loop my analysis macro automatically without me having to execute the analysis macro and paste it to my master listing for 600 times.

So the loop process would be

Execute Loop Macro > Analysis macro will query first csv file from data folder > Result in analysis excel file A & precopied > Paste in master listing excel file B > Clear the query in analysis file A >Analysis macro will query the next csv file from data folder ... & it will loop until all the csv file in the data folder has been completed

Any guidance provided here will be very much appreciated.

 

[Jeffrey Mahoney]

Yes, it is possible. I've done this a 1,000 times or more. This would be a back and forth process. I need your macro posted. Also, the format of your final data and a look at your data files.