Separating Workbooks

  • Thread starter Thread starter smandula
  • Start date Start date
S

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
 
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
 
Thanks --- works very well.

Not to be ungratefull!

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

Again with Thanks
 
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
 
Hi Gord,


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

Your solution is the most elegant.

Many Thanks again.
 
Back
Top