Quickly accessing file in another excel instance

[benjammin75]

Hi,

I am running excel 2010 on windows 7 and due to the memory limitation in one session of excel (ours keel over when they hit 900MB) we are forced to run 2 separate instances.

In each of the sessions we have a number of workbooks open. The problem we have is quickly switching from a workbook in one instance to a workbook in the other instance (as workbooks in the 2nd instance do not show up in the switch windows drop down we have). Navigating using the taskbar is difficult as we have a number of workbooks open, many with similar names. Speed of switching is very important to us.

My question is...is there any quick way to do this? What I think I need is a macro that will switch us to the second instance with the desired workbook as the principal focus. Anyone any idea how I code this?

Many thanks.

 

[HeyYouYesYouNoNotYouYou]

Hi benjammin75,
What I would do is have macros with easily identifiable names which can open workbooks, although im not sure if this would give you the desired effect due to you having multiple instances. The code I would use would be;

Sub openworkbook()
Dim WB As Workbook


On Error Resume Next
Set WB = Workbooks("name of workbook")


If Err <> 0 Then
    On Error GoTo 0
    Workbooks.Open ("workbook location")
End If


End Sub

HeyYouYesYouNoNotYouYou

 

[benjammin75]

Hi,

thanks for the reply but this won't work unless the workbook is in the same session of excel..