Loop a macro through the multiple files

Hello members,
I have already recorded a macro and created an add-in for my CSV files.
I have more than 1000 csv files and I have to open the files one by one and run the add-in for each and then save & close.
How can I run the add-in for all files in a folder without opening each separately?

Thank you

** I have changed the topic based on the comments to find the best solution.