• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

How to set maximizing window for Excel?

E

Eric

Flightless Bird
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
 
J

Johnw

Flightless Bird
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.
 
E

Eric

Flightless Bird
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.
>
>
> .
>
 
T

Tom Willett

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

"Eric" <Eric@discussions.microsoft.com> 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.
: >
: >
: > .
: >
 
S

SC Tom

Flightless Bird
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" <Eric@discussions.microsoft.com> 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.
>>
>>
>> .
>>
 
B

Bob I

Flightless Bird
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
>
 
P

PA Bear [MS MVP]

Flightless Bird
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
 
B

Bernd

Flightless Bird
-------- 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
 
E

Eric

Flightless Bird
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
> .
>
 
E

Eric

Flightless Bird
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
> >

>
> .
>
 
E

Eric

Flightless Bird
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" <Eric@discussions.microsoft.com> 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.
> >>
> >>
> >> .
> >>

>
> .
>
 
B

Bob I

Flightless Bird
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
>>>

>>
>>.
>>
 
E

Eric

Flightless Bird
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
> >>>
> >>
> >>.
> >>

>
> .
>
 
Top