Queener Posted February 7, 2014 Share Posted February 7, 2014 for some reason this code doesn't seems to effect when I run the following code: global $title = "Microsoft Excel" if WinExists($title) Then WinActivate($title) winactive($title) sleep(1000) ControlClick($title, "", "[CLASS:Button; INSTANCE:1]") EndIf Can someone verify? Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.") Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted February 7, 2014 Moderators Share Posted February 7, 2014 How about a more defined explanation of what you are trying to do? With the Excel UDF, I am quite sure there is an easier way than using ControlClicks. "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
water Posted February 7, 2014 Share Posted February 7, 2014 That's corect. Don't automate the GUI, use COM by using the Excel UDF (or my rewrite). My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Queener Posted February 7, 2014 Author Share Posted February 7, 2014 (edited) Nevermind, I figured. recorded macros then have autoit execute the macros. Edited February 7, 2014 by asianqueen Msgbox(0, "Hate", "Just hate it when I post a question and find my own answer after a couple tries. But if I don't post the question, I can't seem to resolve it at all.") 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