run macro in workbook1 then go to workbook2 to run macro

[kbenjamin827]

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]

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().