Results 1 to 3 of 3
2012-08-03, 12:00 #1
- Join Date
- Mar 2002
- Newcazzle, UK
- Thanked 572 Times in 544 Posts
working with multiple excel sessions
I have a two Excel sessions running (both Excel2003), using an extended desktop on 2 screens.
On my left screen, I have two multi-sheet excel data files (of similar structure), arranged horizontally with synchronised scrolling.
On my right screen, I have two files opened: one with macros, and another excel data file with a similar multi-sheet structure as those in my left window.
In my macro file, I have a macro with a shortcutkey assigned.
I press this keyboard shortcut when I'm looking at my excel data file on the right-hand monitor.
What it does is synchronise all three excel datafiles to show the same sheet, the same scroll row and the same scroll column for all three files i.e. the two on my left screen and the one I am looking at on the right screen.
It did exactly what I wanted yesterday.
Today, it doesn't.
1. I know the names of all the files.
2. I have assigned and know the Application Caption for my 'left-hand' Excel instance.
Has anyone done anything similar??
I know Hans recommends you only use one instance of Excel, but blimey, we've got lots of gigabertz and gigabytes these days, so why not use 'em.
2012-08-04, 13:50 #2
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Hi zeddyOK I am sorry this post does not contain an answer for you but:1) Have you tried stepping into the macro code line by line and see whet line fails or what is happening that you disgruntled as "Not working"2) Having two Excel sessions is undesirable for many reasons IMHO.You cant save files properly while open in multiple sessions. Maybe Excel gets confused what session it needs yo work with.Having a fast machine with lots of RAM and disk spsce does not a good reason make. I will advise against it as wellWassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>
2012-08-06, 08:39 #3
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 203 Times in 187 Posts
What's the macro? More specifically, how do you get a reference to the other instance of Excel?Regards,
Microsoft MVP - Excel