Maximized vs minimized

[daniels012]

I have a macro that copies data from disc drive A: and copies it to th
current open spreadsheet. All works fine, except when it's done i
minimizes the window.

What code could I add to maximize the active window?

Something like:
ActiveWindow.WindowState = ????????

Thank You,
Michae

 

[John P]

Michael

Try,
Application.WindowState = xlMaximized

Cheers

John