hi everyone.

so at work there are 5 reports that have to be run each week. i managed to automate the report individually, but I am hoping that there is a way to open one file, and have that file call each of the 5 reports, run a macro(individual macros as they are all slightly different in each report) then save.

for example, perhaps i will specify the directory of 5 files (the 5 reports) then the vba will loop through the 5 directories, run the vba, save and close.

i have done quite a bit of research and I have managed to extract data from single sheets but I am unable to call a macro from a different workbook.

any ideas would be much appreciated