WaitWindowOpen with Excel (minimized)

dubi99 · Post by **dubi99** » Mon May 07, 2007 6:02 pm

I have Excel minimized (i.e. it's open and minimized in the taskbar with a file loaded already) and want to open it to do some things there. With the following code it sometimes works - somtimes not

Code: Select all

setfocus>Microsoft Office Excel 2003 - Netzanalysen*
Let>WW_TIMEOUT=3
waitwindowopen>Microsoft Office Excel 2003 - Netzanalysen*
Wait>0.1
Press Page Up * 30
Wait>0.1
Press Up * 40
Press Left * 30
Wait>0.1

Not working means for example that the Excel programm window appears but the "Press Page Up * 30" are not being recognized.
Any ideas?

Thank you
-roby

Me_again · Post by **Me_again** » Mon May 07, 2007 6:29 pm

Not tested but here are some ideas:

You don't want to open Excel, it's already open. You want to maximize it. That's WindowAction>1,windowname.

Because it's already open waitwindowopen> doesn't help, I would try WaitWindowChanged> instead.

I would also issue a SetFocus> before hitting it with the keystrokes.

dubi99 · Post by **dubi99** » Mon May 07, 2007 7:38 pm

Thank you very much- that seemed to be it!