Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separating Workbooks
Thanks --- works very well.
Not to be ungratefull! Is it possible to have two separate individual excel's? Again with Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating worksheets into separate workbooks | Excel Discussion (Misc queries) | |||
Separating a master file into many workbooks | Excel Programming | |||
Separating 1 workbook into multiple workbooks | Excel Discussion (Misc queries) | |||
Separating worksheets into new workbooks | Excel Discussion (Misc queries) | |||
Separating one large workbook into several smaller workbooks | Excel Programming |