Wooltown Posted December 2, 2005 Share Posted December 2, 2005 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 Link to comment Share on other sites More sharing options...
jpm Posted December 2, 2005 Share Posted December 2, 2005 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 SvenI 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 Link to comment Share on other sites More sharing options...
GaryFrost Posted December 2, 2005 Share Posted December 2, 2005 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. SciTE for AutoItDirections for Submitting Standard UDFs Don't argue with an idiot; people watching may not be able to tell the difference. Link to comment Share on other sites More sharing options...
Valuater Posted December 2, 2005 Share Posted December 2, 2005 this works on mine While 1 Sleep(2000) WinActivate("Microsoft Excel") Sleep(2000) Send("!W1") Sleep(2000) Send("!W2") WEnd 8) Link to comment Share on other sites More sharing options...
Wooltown Posted December 2, 2005 Author Share Posted December 2, 2005 I will, thanks ! /Sven Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now