Controlling the Excel application with VBA

[Gary''s Student]

I can move and re-size the Excel window using the mouse. Is there an
Application.something_or_other that will allow me to do this with VBA?
--
Gary''s Student

[Norman Jones]

Hi Gary's Student,

Look at the Application's Top, Left, Height, Width and WindoState
properties.


---
Regards,
Norman


"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:3C7D6D23-BD61-44BB-9448-373333A3EFA6@microsoft.com...
>I can move and re-size the Excel window using the mouse. Is there an
> Application.something_or_other that will allow me to do this with VBA?
> --
> Gary''s Student

[Norman Jones]

>WindoState

==>> WindowState


---
Regards,
Norman



"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:e74HJof7FHA.2600@tk2msftngp13.phx.gbl...
> Hi Gary's Student,
>
> Look at the Application's Top, Left, Height, Width and WindoState
> properties.
>
>
> ---
> Regards,
> Norman

[Gary''s Student]

Thank you Norman. once I set the WindowState to xlnormal, things began to
happen
--
Gary''s Student


"Norman Jones" wrote:

>
> >WindoState
>
> ==>> WindowState
>
>
> ---
> Regards,
> Norman
>
>
>
> "Norman Jones" <normanjones@whereforartthou.com> wrote in message
> news:e74HJof7FHA.2600@tk2msftngp13.phx.gbl...
> > Hi Gary's Student,
> >
> > Look at the Application's Top, Left, Height, Width and WindoState
> > properties.
> >
> >
> > ---
> > Regards,
> > Norman
>
>
>