hi again i need to open up 4 ins

shumon · Jul 18, 2003

hi again

i need to open up 4 instances of excel on mu computer. is there a way to automatically positiona and size the window on the screen.
thanks

SkipVought · Jul 18, 2003

From inside Excel, I don't think so, since each instance of Excel has no communication with any other instance.

Skip,
Skip@TheOfficeExperts.com

TonyJollans · Jul 18, 2003

Hi shumon,

Why do you need to open up four instances of Excel. Most everything you want can be (better) done in a single instance.

Enjoy,
Tony

SkipVought · Jul 18, 2003

Here's what might fit your need in a single instance of Excel with 4 workbooks opened...

Code:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/18/2003 by Skip
'

'
    Windows.Arrange ArrangeStyle:=xlArrangeStyleTiled
End Sub

Skip,
Skip@TheOfficeExperts.com