Suppose I have two different excel files.
Workbook1 has macro 'Run1' under Module1 and
Workbook2 has macro 'Run2' under Module1
Is it possible to use the macro 'Run1' in Workbook1 to open Workbook2, run the macro 'Run2' on Workbook2, close and save changes, and switch back to Workbook1 when the macro is completed?
I need to know how to call macros that are in a different workbook.
Any help is deeply appreciated. Thanks.
Workbook1 has macro 'Run1' under Module1 and
Workbook2 has macro 'Run2' under Module1
Is it possible to use the macro 'Run1' in Workbook1 to open Workbook2, run the macro 'Run2' on Workbook2, close and save changes, and switch back to Workbook1 when the macro is completed?
I need to know how to call macros that are in a different workbook.
Any help is deeply appreciated. Thanks.