Separating Workbooks

[smandula]

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

 

[Gord Dibben]

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

 

[smandula]

Thanks --- works very well.

Not to be ungratefull!

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

Again with Thanks

 

[Gord Dibben]

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

 

[smandula]

Hi Gord,


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

Your solution is the most elegant.

Many Thanks again.