Run excel macro (located in another file) for each new file in folder

Hi, i am trying to run an excel macro on a daily basis to all new files added to a folder. can anyone advise how to do that? thank you.

Check this below link, @JR_21

InvokeVBA (14.7 KB)
This may help you :slight_smile: