PDA

View Full Version : run macro in workbook1 then go to workbook2 to run macro



kbenjamin827
07-17-2018, 10:55 AM
I need to run a code in workbook1, then go to workbook 2 and run another code. Without having to go between workbooks. Is there a way?

Kenneth Hobs
07-18-2018, 06:13 PM
Welcome to the forum!

I am not clear about your goal. Please be more specific. e.g. Workbook1 is ActiveWorkbook. It opens Workbook2 and runs Workbook1's Module1.UpdateStuff macro for "Sheet2" in each of the two workbooks. It then saves and closes Workbook2.

If you want to run a macro in another Workbook from an other Workbook, use Application.Run().