Excel Guides

Running a Macro in a Number of Workbooks in Excel

There are a few different ways that you can run a macro in a number of workbooks in Excel. One way is to use the Application.Run method. This method will allow you to run a macro in another workbook, provided that the workbook is open. For example, let's say that you have a macro called "MyMacro" in a workbook called "MyWorkbook.xlsm". You can run this macro from any other open workbook by using the following code:

Application.Run "MyWorkbook.xlsm!MyMacro"

Another way to run a macro in another workbook is to use the Workbooks.Open method. This method will open the specified workbook and then run the macro. For example, let's say that you have a macro called "MyMacro" in a workbook called "MyWorkbook.xlsm". You can run this macro from any other open workbook by using the following code:

Workbooks.Open Filename:="C:\MyWorkbooks\MyWorkbook.xlsm"
Application.Run "MyMacro"
ActiveWorkbook.Close SaveChanges:=False

If you want to run a macro in all open workbooks, you can use the For Each loop. For example, let's say that you have a macro called "MyMacro" and you want to run this macro in all open workbooks. You can use the following code:

For Each wb In Workbooks
    Application.Run "MyMacro"
Next wb

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.