Open new Excelbook and changing windowstate

T

tmarko

I programmaticlally open up a new Excelbook from an existing one.

How can I accomplish that the size of the second one will resemble th
first one. The same Size pattern set by the user of the firs
Excelbook?

In the second Excelbook I code

newExcel.Application.WindowState = xlMaximized

But how do I reset it so it looks like the first one?

If I use

newExcel.Application.WindowState = xlNormal

The size will always decrease to I fixed size independently of how th
inital Excelbook looked like from where I opened up the Excelbook
resize.

So what exactly is xlNormal by the way
 
Top