How to set maximizing window for Excel?

E

Eric

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

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

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
 
T

Tom Willett

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

: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

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.
 
B

Bob I

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
 
B

Bernd

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

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
 
E

Eric

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
 
E

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
 
B

Bob I

Is the macro actually installed?
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


:
 
E

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
 
B

Bernd

-------- Original-Nachricht --------
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
1. Add the file C:\documents\abc.xls to the 2nd line of the script:

Set WshShell = WScript.CreateObject("WScript.Shell")
Return = WshShell.Run("excel C:\documents\abc.xls" , 3)

2. Save the 2 lines as xyz.vbs file

3. Substitute Excel by xyz.vbs within the scheduled task

I've tested it, it works

Bernd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top