Quickly accessing file in another excel instance

benjammin75

New Member
Joined
Jan 14, 2014
Messages
2
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.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Joined
Dec 17, 2013
Messages
37
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;
Code:
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

New Member
Joined
Jan 14, 2014
Messages
2
Hi,

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

Watch MrExcel Video

Forum statistics

Threads
1,122,561
Messages
5,596,845
Members
414,107
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top