Separating Workbooks
 

I have VBA code calling a second Workbook

Private Sub Workbook_Open()
Workbooks.Open ("C:\Documents and Settings\Owner\My Documents
\MicroXSLX.xlsm")
End Sub

However, I can not visually separate the two workbooks, as they
overlap each other.

The two workbook icons are both visible in the Task bar.

I would like to see both workbooks separately.

With Thanks

Separating Workbooks
 

Stick this macro in a General Module in workbook one

Sub Tile_Open()
Windows.Arrange ArrangeStyle:=xlVertical
End Sub

Add a Call in your opening code

Private Sub Workbook_Open()
Workbooks.Open ("C:\Documents and Settings\Owner\My Documents
\MicroXSLX.xlsm")
Call Tile_Open
End Sub



Gord


On Tue, 29 Nov 2011 12:03:42 -0800 (PST), smandula
wrote:

I have VBA code calling a second Workbook

Private Sub Workbook_Open()
Workbooks.Open ("C:\Documents and Settings\Owner\My Documents
\MicroXSLX.xlsm")
End Sub

However, I can not visually separate the two workbooks, as they
overlap each other.

The two workbook icons are both visible in the Task bar.

I would like to see both workbooks separately.

With Thanks

Separating Workbooks
 

Thanks --- works very well.

Not to be ungratefull!

Is it possible to have two separate individual excel's?

Again with Thanks

Separating Workbooks
 

It is possible to have two separate instances of Excel running.

Open one instance and load a workbook then open another instance and
open a workbook in that.

NOTE: the separate instances cannot communicate with each other.


Gord


On Tue, 29 Nov 2011 13:19:31 -0800 (PST), smandula
wrote:

Thanks --- works very well.

Not to be ungratefull!

Is it possible to have two separate individual excel's?

Again with Thanks

Separating Workbooks
 

Hi Gord,


What I was looking for does not exist, except
by manual doing.

Your solution is the most elegant.

Many Thanks again.