How can I run a macro on multiple workbooks at once?

[Simon4s]

I have 250 CSV workbooks with the same type of data. The moment I open these files, I run "custom macro 1" to reorganize the data. How can I apply this macro to all my files in any order?

More detail: After this is done, I'm going to merge my workbooks together. I can't merge them before hand because the files are going to be too big. "Custom macro 1" would run for days.

Thanks,
Simon

 

[Alex Blakenburg]

Are the workbooks in the same format ? Have you considered a Power Query solution ?

 

[Simon4s]

Are the workbooks in the same format ? Have you considered a Power Query solution ?

Yes, all the workbooks are in the same format. No I have not considered Power Query? I have never heard of this.

 

[Alex Blakenburg]

You might want to update your profile to show what version of excel you are running.

Here is an article along the lines of your requirement.

https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder

 

[Joe4]

If you Google "Excel VBA run macro on all files in a folder", you will see many results that show you how to do this.
Here is one to get you started: VBA Run Macro on All Files in a Folder / All Worksheets in a Workbook - Analyst Cave