Best way to run a macro on every xlsx file in document?

[tonywatsonhelp]

Hi Everyone,
I was hoping someone could help me.
I need a macro that can got to a folder

FOLDER_PATH = "F:\MY Docs1\New1\Run New Project\Data 1 sheets"

and open every xlsx doc only then run a macro call "repair1" then close and save

any ideas the best way to do this bearing in mind the folder has other doc such as txt, csv. and xlsm in it as well?

Thanks

Tony

 

[Macropod]

There have been many threads here on how to process all files of a given type in a folder (e.g. https://www.mrexcel.com/forum/excel...ro-all-workbooks-folder.html?highlight=folder). You should do a search...