Controlling multiple instances

**sekrah** · 01-08-2011, 03:13 PM

Let's say I have two seperate instances of Excel open. Is it possible to use VBA in the one instance, have it copy/paste over to an open workbook in the other instance?

If so, how?

**royUK** · 01-08-2011, 03:45 PM

Why have two instances open?

**sekrah** · 01-08-2011, 04:01 PM

Dual screen monitor, can only have spreadsheets on both if there's two instances. Or is there a way to open two workbooks from the same instance and move one to the other screen? I didn't think that was possible.

**shg** · 01-08-2011, 04:03 PM

You can spread the single instance across both monitors, and arrange windows to have one workbook on each side. I do it frequently.

**sekrah** · 01-09-2011, 06:37 AM

shg..

I'm not quite sure how to do what your saying. When I open Excel, it opens in the one window. Any worksheet I try to drag to the other screen stops at the edge of the screen and won't go past the first instance. The only way it lets me move Excel between my monitors is by Restore and dragging the entire instance into the other monitor.

How would I go about setting it up to do what yours does?

**shg** · 01-09-2011, 11:58 AM

Restore (unmaximize) the window, and drag an edge across the monitor boundary. Resize to fill both monitors(or as their varying resolutions permit).

Windows > Arrange