How to control which vba Excel program has control on computer

[stevespauldi]

I have two separate vba Excel programs which interact with each other.

Right now, whichever program I open first (and enable macros) has control on my computer (even when I programmatically activate a window in the other program).

There are times I want vba control to be taken by the other program. How do I control which program has control (vba/macro-wise) on my computer?

Thanks,
Steve

[Paul_Hossler]

Question: two instances of Excel.exe each with one workbook, OR 2 workbooks open in a single instance of Excel.exe?

Paul

[Aussiebear]

I'd say from reading the post Paul, that he's talking about the first.

[Paul_Hossler]

I'd say from reading the post Paul, that he's talking about the first.

Just wanted to understand since activating another workbook is very different from activating another instance of Excel.

We have a guy at work who's (in)famous for have 3 or more Excel instances open with 2 or more workbooks in some of them. He wonders why he has crashes and macro and ribbon disconnects.

I have two separate vba Excel programs which interact with each other.

Steve -- can you use one Excel instance, with 2 macro workbooks?

Paul

[SamT]

[vba]
Dim objThatOtherBook As Workbook
If Not Workbooks("Other Book's Name") IsNothing Then 'Book is open
Set objThatOtherBook = Workbooks("Other Book's Name")
Else 'book is not open
Exit Sub
End If

Call objThatOtherBook.MacroName()
' OR
Call objThatOtherBook.ModuleName.MacroName()
'where ModuleName is the name of the module the macro is in

[/vba]

[stevespauldi]

I have two separate Excel workbooks (both with vba macros).

- Steve