Macro to open other Excel files, run a specific Macro, and close?

[Bret1]

I have multiple Excel worksheets that I open daily, run a Macro that pulls specific data and automatically saves with today's date. I would like to simply my efforts. Is it possible to create a Macro in a new worksheet that I can set to open other specific worksheets (in separate folders), run a specific Macro that is saved in that worksheet, close the file after Macro completes, then open next worksheet listed?

 

[MountainFog]

Something along these lines should work. I don't quite understand the specifics of what you want to do
Pathname is the string of the file path of the workbook to be opened
RunSub is the name of the macro in that workbook

Sub OpenWorkbooksAndRunMacros()
    
    Workbooks.Open PATHNAME
    RunSub
    Workbooks.Close PATHNAME
    

End Sub

 

[Bret1]

Something along these lines should work. I don't quite understand the specifics of what you want to do
Pathname is the string of the file path of the workbook to be opened
RunSub is the name of the macro in that workbook

Sub OpenWorkbooksAndRunMacros()
   
    Workbooks.Open PATHNAME
    RunSub
    Workbooks.Close PATHNAME
   

End Sub

Thanks!