VBA Genuis

[JerryKaminsky]

Has anyone figured out a way via vba code to have one excel instance open with multiple files across multiple monitors. I realize that there is hardware that does this or a registry hack. The first is out of the budget and the second will not be supported in the firm. I would think that MS would have thought of this.

Peace Out.....

 

[bensonsearch]

Hi,
please clarify as im confused (not a hard thing)

you wish to have excel opening different files on different screens?

lets say 2 screens each with 1 different file?

 

[chuckchuckit]

I usually run 8 individual screens most days from 1 computer. Have anywhere from 3 to 8 (or more) instances of Excel running at one time. Many of them are automated running queries all day long. Some use full screens, some run minimized or reduced size. The only cost there was the two video cards to run 4 monitors each (plus the monitors of course).

Start of day I just open them one at a time. It does not take that long to set them up. I do not think I would gain that much by having them automatically opened for me, as I often change what I am using anyway.

 

[JerryKaminsky]

Let me give you all the facts as I appologize. You may be a genius but not a mind reader. Here are the facts:

I have a laptop with an Intel I5 processor with embedded HD video.

I have a lenovo 22" monitors attached via the VGA port.

I want two Excel files open, one on the la[ptop and one one the monitor.
When I try to use the formula "=" on one cell and reference the other workbook. it does not work.

Any thoughts?

 

[shg]

Unlike Word, that's not Excel's document interface. You can spread the Excel window over two monitors, and arrange windows within that, but not do what you want to do in a single instance of Excel.

It would be convenient, and lots of people ask, but it just doesn't work that way.

 

[JerryKaminsky]

Then the only option is to purchase hardware to give me another graphics card

 

[shg]

I don't know how that is going to work any differently; Excel (through 2007) only has one main window.

 

[chuckchuckit]

Hi Jerry,

Was wondering if you give a bit more info on what you would be wanting to do. There might be some ways to do a work around, but more info would help, such as:

1. Are you just wanting a duplicate mirror copy of Excel on a different monitor2 to mimic any changes you make on monitor1 ?

2. If so can you give more real time info like - is it for an other viewer to see the work changes? And other info like: how soon would monitor2 need to show those changes in montor1 ? Or maybe better question would be - what would be the acceptable lag time for monitor2 update ? etc, etc.

I have some ideas how to do that (in my un-orthodoxed VBA ways as I am not Excel schooled so I go about programming a bit differently perhaps).

Poster here "shg" is excellent with code. Any ideas we might have "shg" likely could say it can or can not be done, or he might have a better way to go about it.

VBA challenges like the one you have presented is intriguing not only to me but many here I would think. So if you can explain as much as you can about what exactly the "requirements are" we might be able to come up with some ideas.

Hope you are not having to read my mind there on my thoughts...

I'm gone for a couple hrs, be back.

Chuck

 

[JerryKaminsky]

i spoke to the person actually looking for the solution. I hope this is clearer.
I don’t think that what we want. Rather this: either the same instance of excel with the ability to view two worksheets on different monitors (that is not a mirror of a monitor but rather a mirror of excel) or two have two instances of excel with the ability for one instance to “talk” to the other……linking, formula creation etc.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Does that make sense?<o></o>

 

[shg]

It makes eminent sense, so you could, for example, cut and paste formats from one workbook to the other in the usual way you can in two workbooks open in the same instance of Excel. I can only repeat:

Excel doesn't work that way.