WinActivate doesn't work in Child Windows

[Wooltown]

Opt("WinSearchChildren", 1)

WinActivate ("Microsoft Excel")
WinActivate ("Book2")
Sleep (2000)
Send ("aa")

In Excel, I have 2 Sheets, "Book1" and "Book2", Book 1 is on top, I can't get "Book2" activated, the script will write "aa" on "Book1".

Regards

Sven

[jpm]

Opt("WinSearchChildren", 1)

WinActivate ("Microsoft Excel")
WinActivate ("Book2")
Sleep (2000)
Send ("aa")

In Excel, I have 2 Sheets, "Book1" and "Book2", Book 1 is on top, I can't get "Book2" activated, the script will write "aa" on "Book1".

Regards

Sven

I don't think Book2 is a window accessible with autoit. You can verify that "AutoIt info tool" does not return such window.

NO BUG

PS It is always good to start with the support forum before writing a BUG. Thanks

[GaryFrost]

Opt("WinSearchChildren", 1)

WinActivate ("Microsoft Excel")
WinActivate ("Book2")
Sleep (2000)
Send ("aa")

In Excel, I have 2 Sheets, "Book1" and "Book2", Book 1 is on top, I can't get "Book2" activated, the script will write "aa" on "Book1".

Regards

Sven

You might want to take a look at ExcelCom UDF it probably deals with what your wanting to do.

[Valuater]

this works on mine

While 1
    
    Sleep(2000)
    WinActivate("Microsoft Excel")
    
    
    Sleep(2000)
    Send("!W1")
    
    Sleep(2000)
    Send("!W2")
WEnd

8)

[Wooltown]

I will, thanks !

/Sven