Run macro for multiple excel files in a folder

Hi guys, i have a macro that i need to run on many excel files. All of the files are located in the same folder.

The macro, is a find/replace which uses data from a sheet ("sheet 2" in this case) and changes the data in "sheet 1".

All of the excel files have only one sheet and the sheet name is the same which the nam,e of the file. For example:

file name : 3 - 4
sheet name : 3 - 4

This is the macro that i use, big thanks to Leith Ross for writing it.

Please Login or Register  to view this content.

Also the method should allow me to change which macro I want to run.

Thanks a lot for the help

So i think i managed to make it work

In the MultiReplace sub I've done some modifications

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

for the loop i've used this

Please Login or Register  to view this content.

the spreadsheet should be in a folder and the files you want run the macro on should be in a new folder (inside that folder)

and now i'm able to run the find/replace macro on all my files :>