Manipulating hidden windows

[Marcelão]

AU3 Friends,

I have an AutoIt script that is typing values into a hidden document (a xls file).

...

Run("C:\Program Files\Microsoft Office\OFFICE11\excel.exe", "", @SW_HIDE)

WinWait("Microsoft Excel")

...

The script runs until a "save as" is requested:

...

ControlSend("Microsoft Excel", "", "MsoCommandBar4", "^s") ; ---> "Save as" request

WinWait("Save As")

...

The first "WinWait" works and the second doesn't. If the parameter @SW_HIDE is changed to @SW_MAXIMIZE, the script runs sucessfully until the end.

I think the problem is about working with a hidden window calling a pattern system window.

Have you already seen any situation (and a solution) for this? (If it exists)

Thanx

Edited July 14, 2006 by Marcelão

[jvanegmond]

If you're going to use Excel, why not use the Excel UDF?

[Marcelão]

If you're going to use Excel, why not use the Excel UDF?

Hello Manadar,

This example I'm programming is just a simulation to how to deal with hidden windows. In fact I have a big AutoIt code working with a lot of maximized windows from Siebel Tools and Siebel Client.

If I found the solution for this "save as" window from Excel I'll find the solution for all the "sabe as" and "open" window from Siebel - they are pattern from window.

Thanx for your reply

[jvanegmond]

Sorry mate, i only saw the "Posts: 3" and i figured you had little scripting experience. Can't really help you, so good luck with that.