PDA

View Full Version : [SOLVED:] vba macro to run multiple macros in multiple workbooks



jthompson011
10-27-2016, 09:25 AM
I'm trying to create a macro on a new workbook that will do a few things. I need it to open a separate excel file (FileA), run a macro thats in FileA, save FileA, then close FileA and move onto the next (FileB). I think I'm good with the code for opening, closing and saving FileA, however I'm not sure the best way to instruct vba to run a macro within a macro. Any ideas?

SamT
10-27-2016, 12:25 PM
FileA Name + dot + File A Module name + dot + macro name + Parameters

Paul_Hossler
10-27-2016, 01:25 PM
Also make sure you understand the difference between ActiveWorkbook and ThisWorkbook and that all of the macros are setup correctly