Re-post: How to maximize the Excel window?

[Eric]

I set schedule to open excel file, when it opens, the excel window's size is
not maximized, and I have tried your approach, for manually opened
approach, it works, but it still does not work on opening excel file, which
is triggered by schedule task. Do you have any suggestions?
Thanks in advance for any suggestions
Eric

 

[Gary Keramidas]

try putting the code in the thisworkbook module

Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub

 

[Eric]

I have set the property of Excel with maximizing window, when excel is
manually opened, it shows in maximized window's size, but when schedule task
activates to open excel file, the excel window's size is not maximized. On
the other hands, the given coding works fine, if Excel is opened manually, so
the issue is when excel is opened and triggered by schedule task, Excel
cannot be maximized window's size.
Do you have any suggestions?
Thanks in advance for any suggestions
Eric

 

[Dave Peterson]

Check your other thread.

I set schedule to open excel file, when it opens, the excel window's size is
not maximized, and I have tried your approach, for manually opened
approach, it works, but it still does not work on opening excel file, which
is triggered by schedule task. Do you have any suggestions?
Thanks in advance for any suggestions
Eric