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

2

1 Answer 1

2

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .