Switching between Excel instances

[MaximS]

Hi there,

Does anyone knows how to navigate between 2 or more Excel instances with some workbooks open?

[Kenneth Hobs]

Does GetObject() help?

Using c#, this method might help. http://support.microsoft.com/kb/316126

Another article using .Net's vb or c#: http://support.microsoft.com/kb/238610

[MaximS]

Thanks Kenneth I will have go with yours proposals.

I have already found solution which works for me:



Dim OtherExcel As Application
Dim BookToFind As Workbook

Set BookToFind = GetObject("c:\docs\file.xls")
'if you need to access the Application object of the other Excel instance:
Set OtherExcel = BookToFind.Parent