How to set maximizing window for Excel?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Guest
Does anyone have any suggestions on how to maximize the excel window whenever

I open excel?

I have set Excel application's property into maximizing window, but I get

many excel files and shortcuts, which property are set into normal mode.

Does anyone have any suggestions on how to open in maximizing windown for

Excel?

Thanks in advance for any suggestions

Eric
 
Eric expressed precisely :

> Does anyone have any suggestions on how to maximize the excel window whenever

> I open excel?

> I have set Excel application's property into maximizing window, but I get

> many excel files and shortcuts, which property are set into normal mode.

> Does anyone have any suggestions on how to open in maximizing windown for

> Excel?

> Thanks in advance for any suggestions

> Eric



Try this way.



1: Open Excel, then maximize.



2: Now use the exit ( not the X ) File ( top l/h side ) > Exit.
 
I have tried, it only work if I manually open excel,

I set schedule to open excel file at specific time, once it opens, the excel

window's size is not maximized.

Do you have any suggestions on how to set maximizing the excel window's

size? which is activated by schedule task.

Thanks in advance for any suggestions

Eric



"Johnw" wrote:



> Eric expressed precisely :

> > Does anyone have any suggestions on how to maximize the excel window whenever

> > I open excel?

> > I have set Excel application's property into maximizing window, but I get

> > many excel files and shortcuts, which property are set into normal mode.

> > Does anyone have any suggestions on how to open in maximizing windown for

> > Excel?

> > Thanks in advance for any suggestions

> > Eric

>

> Try this way.

>

> 1: Open Excel, then maximize.

>

> 2: Now use the exit ( not the X ) File ( top l/h side ) > Exit.

>

>

> .

>
 
Did you try asking the experts in the Excel newsgroup(s)?



"Eric" wrote in message

news:5979CFCE-0A52-45B9-BB47-89353050564C@microsoft.com...

:I have tried, it only work if I manually open excel,

: I set schedule to open excel file at specific time, once it opens, the

excel

: window's size is not maximized.

: Do you have any suggestions on how to set maximizing the excel window's

: size? which is activated by schedule task.

: Thanks in advance for any suggestions

: Eric

:

: "Johnw" wrote:

:

: > Eric expressed precisely :

: > > Does anyone have any suggestions on how to maximize the excel window

whenever

: > > I open excel?

: > > I have set Excel application's property into maximizing window, but I

get

: > > many excel files and shortcuts, which property are set into normal

mode.

: > > Does anyone have any suggestions on how to open in maximizing windown

for

: > > Excel?

: > > Thanks in advance for any suggestions

: > > Eric

: >

: > Try this way.

: >

: > 1: Open Excel, then maximize.

: >

: > 2: Now use the exit ( not the X ) File ( top l/h side ) > Exit.

: >

: >

: > .

: >
 
Each Excel file is going to open in the same state it was closed in. If it

was maximized when closed, it will re-open maximized. I don't know of any

command line switches you can use with Scheduled Tasks to maximize it once

it's opened, but you might try the Excel newsgroups or forums for

suggestions.

--

SC Tom



"Eric" wrote in message

news:5979CFCE-0A52-45B9-BB47-89353050564C@microsoft.com...

>I have tried, it only work if I manually open excel,

> I set schedule to open excel file at specific time, once it opens, the

> excel

> window's size is not maximized.

> Do you have any suggestions on how to set maximizing the excel window's

> size? which is activated by schedule task.

> Thanks in advance for any suggestions

> Eric

>

> "Johnw" wrote:

>

>> Eric expressed precisely :

>> > Does anyone have any suggestions on how to maximize the excel window

>> > whenever

>> > I open excel?

>> > I have set Excel application's property into maximizing window, but I

>> > get

>> > many excel files and shortcuts, which property are set into normal

>> > mode.

>> > Does anyone have any suggestions on how to open in maximizing windown

>> > for

>> > Excel?

>> > Thanks in advance for any suggestions

>> > Eric

>>

>> Try this way.

>>

>> 1: Open Excel, then maximize.

>>

>> 2: Now use the exit ( not the X ) File ( top l/h side ) > Exit.

>>

>>

>> .

>>
 
Record a macro of you pressing Alt+Space, then X, and name it Auto_Open



Or past this into the VB editor



Sub Auto_Open()



Application.WindowState = xlMaximized

End Sub







Eric wrote:



> Does anyone have any suggestions on how to maximize the excel window whenever

> I open excel?

> I have set Excel application's property into maximizing window, but I get

> many excel files and shortcuts, which property are set into normal mode.

> Does anyone have any suggestions on how to open in maximizing windown for

> Excel?

> Thanks in advance for any suggestions

> Eric

>
 
See replies to your original post about this (as usual).



Eric wrote:

> Does anyone have any suggestions on how to maximize the excel window

> whenever I open excel?

> I have set Excel application's property into maximizing window, but I get

> many excel files and shortcuts, which property are set into normal mode.

> Does anyone have any suggestions on how to open in maximizing windown for

> Excel?

> Thanks in advance for any suggestions

> Eric
 
-------- Original-Nachricht --------



> Does anyone have any suggestions on how to maximize the excel window whenever

> I open excel?

> I have set Excel application's property into maximizing window, but I get

> many excel files and shortcuts, which property are set into normal mode.

> Does anyone have any suggestions on how to open in maximizing windown for

> Excel?

> Thanks in advance for any suggestions

> Eric

>



Start Excel in Task Scheduler using following Vbs file:



Set WshShell = WScript.CreateObject("WScript.Shell")

Return = WshShell.Run("excel " , 3)



Background for the parameter "3":



http://msdn.microsoft.com/en-us/library/d5fk67ky(VS.85).aspx?ppud=4



Bernd
 
Could you please tell me how to add the given VB code into schedule task?

For example, the path for file is C:\documents\abc.xls

Do you have any suggestions?

Thanks in advance for any suggestions

Eric



"Bernd" wrote:



>

>

> -------- Original-Nachricht --------

>

> > Does anyone have any suggestions on how to maximize the excel window whenever

> > I open excel?

> > I have set Excel application's property into maximizing window, but I get

> > many excel files and shortcuts, which property are set into normal mode.

> > Does anyone have any suggestions on how to open in maximizing windown for

> > Excel?

> > Thanks in advance for any suggestions

> > Eric

> >

>

> Start Excel in Task Scheduler using following Vbs file:

>

> Set WshShell = WScript.CreateObject("WScript.Shell")

> Return = WshShell.Run("excel " , 3)

>

> Background for the parameter "3":

>

> http://msdn.microsoft.com/en-us/library/d5fk67ky(VS.85).aspx?ppud=4

>

> Bernd

> .

>
 
If I open excel manually, it works.



However, a schedule task is set to open excel file, when it opens, the excel

window's size is not maximized, which is triggered by schedule task. Do you

have any suggestions?

Thanks in advance for any suggestions

Eric





"Bob I" wrote:



> Record a macro of you pressing Alt+Space, then X, and name it Auto_Open

>

> Or past this into the VB editor

>

> Sub Auto_Open()

>

> Application.WindowState = xlMaximized

> End Sub

>

>

>

> Eric wrote:

>

> > Does anyone have any suggestions on how to maximize the excel window whenever

> > I open excel?

> > I have set Excel application's property into maximizing window, but I get

> > many excel files and shortcuts, which property are set into normal mode.

> > Does anyone have any suggestions on how to open in maximizing windown for

> > Excel?

> > Thanks in advance for any suggestions

> > Eric

> >

>

> .

>
 
I think this issue is related to XP more than Excel,

If I open excel manually, it displays in maximizing window's size for Excel.



However, a schedule task is set to open excel file, when it opens, the excel

window's size is not maximized, which is triggered by schedule task. Do you

have any suggestions?

Thanks in advance for any suggestions

Eric







"SC Tom" wrote:



> Each Excel file is going to open in the same state it was closed in. If it

> was maximized when closed, it will re-open maximized. I don't know of any

> command line switches you can use with Scheduled Tasks to maximize it once

> it's opened, but you might try the Excel newsgroups or forums for

> suggestions.

> --

> SC Tom

>

> "Eric" wrote in message

> news:5979CFCE-0A52-45B9-BB47-89353050564C@microsoft.com...

> >I have tried, it only work if I manually open excel,

> > I set schedule to open excel file at specific time, once it opens, the

> > excel

> > window's size is not maximized.

> > Do you have any suggestions on how to set maximizing the excel window's

> > size? which is activated by schedule task.

> > Thanks in advance for any suggestions

> > Eric

> >

> > "Johnw" wrote:

> >

> >> Eric expressed precisely :

> >> > Does anyone have any suggestions on how to maximize the excel window

> >> > whenever

> >> > I open excel?

> >> > I have set Excel application's property into maximizing window, but I

> >> > get

> >> > many excel files and shortcuts, which property are set into normal

> >> > mode.

> >> > Does anyone have any suggestions on how to open in maximizing windown

> >> > for

> >> > Excel?

> >> > Thanks in advance for any suggestions

> >> > Eric

> >>

> >> Try this way.

> >>

> >> 1: Open Excel, then maximize.

> >>

> >> 2: Now use the exit ( not the X ) File ( top l/h side ) > Exit.

> >>

> >>

> >> .

> >>

>

> .

>
 
Is the macro actually installed?



Eric wrote:



> If I open excel manually, it works.

>

> However, a schedule task is set to open excel file, when it opens, the excel

> window's size is not maximized, which is triggered by schedule task. Do you

> have any suggestions?

> Thanks in advance for any suggestions

> Eric

>

>

> "Bob I" wrote:

>

>

>>Record a macro of you pressing Alt+Space, then X, and name it Auto_Open

>>

>>Or past this into the VB editor

>>

>>Sub Auto_Open()

>>

>> Application.WindowState = xlMaximized

>>End Sub

>>

>>

>>

>>Eric wrote:

>>

>>

>>>Does anyone have any suggestions on how to maximize the excel window whenever

>>>I open excel?

>>>I have set Excel application's property into maximizing window, but I get

>>>many excel files and shortcuts, which property are set into normal mode.

>>>Does anyone have any suggestions on how to open in maximizing windown for

>>>Excel?

>>>Thanks in advance for any suggestions

>>>Eric

>>>

>>

>>.

>>
 
It seems to me that not able to maximize window is related to schedule task

function under XP, since when I manually open excel file, it can maximize the

window's size, but the excel window size cannot be maximized if the same file

is opened by schedule task at specific time.

Do you have any suggestions?

Thanks in advance for any suggestions

Eric



"Bob I" wrote:



> Is the macro actually installed?

>

> Eric wrote:

>

> > If I open excel manually, it works.

> >

> > However, a schedule task is set to open excel file, when it opens, the excel

> > window's size is not maximized, which is triggered by schedule task. Do you

> > have any suggestions?

> > Thanks in advance for any suggestions

> > Eric

> >

> >

> > "Bob I" wrote:

> >

> >

> >>Record a macro of you pressing Alt+Space, then X, and name it Auto_Open

> >>

> >>Or past this into the VB editor

> >>

> >>Sub Auto_Open()

> >>

> >> Application.WindowState = xlMaximized

> >>End Sub

> >>

> >>

> >>

> >>Eric wrote:

> >>

> >>

> >>>Does anyone have any suggestions on how to maximize the excel window whenever

> >>>I open excel?

> >>>I have set Excel application's property into maximizing window, but I get

> >>>many excel files and shortcuts, which property are set into normal mode.

> >>>Does anyone have any suggestions on how to open in maximizing windown for

> >>>Excel?

> >>>Thanks in advance for any suggestions

> >>>Eric

> >>>

> >>

> >>.

> >>

>

> .

>
 
You must log in or register to reply here.
Back
Top