Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 from "AAA" macro in instance 1
Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2 i want to call "ASD" in instance 2 from "AAA" macro in instance 1
There are a few ways to do this, but the easiest is to use Application.Run()
. As an example, I have a workbook named "SC Fun.xlsm" in order to run my getData()
subroutine in that workbook, from another workbook, I can write:
Sub runAnotherWokbooksMacro()
Application.Run "'SC Fun.xlsm'!getData"
End Sub