pradisdeep Posted July 18, 2014 Share Posted July 18, 2014 (edited) I am unable to loop the below code with the above given example... need help !!!expandcollapse popup_WinWaitActivate("Microsoft Excel - Book2","Status Bar") Sleep(500) Send("!H") Send("C") Send("C") Sleep(500) _WinWaitActivate("BAR.BMC - Process Account - (BNJ/BNJ.LIVEN/BNJ.LIVEN) - Predee - \\Remote, 256-bit SSL/TLS.","") MouseClick("right",160,153,1) Send("{DOWN}{DOWN}{DOWN}{DOWN}") Sleep(500) Send("{ENTER}") Sleep(1000) Send("{ENTER}") Sleep(2500) Send("{ENTER}") Sleep(2500) MouseClick("left",1169,603,1) Sleep(2500) MouseClick("left",791,128,1) Sleep(2500) MouseClick("left",314,839,1) Sleep(2500) _WinWaitActivate("BAR.BMC - Enter Comment - \\Remote, 256-bit SSL/TLS.","") Sleep(2500) MouseClick("left",171,349,1) _WinWaitActivate("Microsoft Excel - Book2","") MouseClick("left",124,197,1) Sleep(2500) Send("!H") Send("C") Send("C") _WinWaitActivate("BAR.BMC - Enter Comment - \\Remote, 256-bit SSL/TLS.","") MouseClick("right",146,345,1) Sleep(500) Send("{DOWN}{DOWN}{DOWN}{DOWN}") Sleep(500) Send("{ENTER}") Sleep(1000) _WinWaitActivate("Microsoft Excel - Book2","Status Bar") Send("{LEFT}") Send("{DOWN}") Sleep(500) Edited July 18, 2014 by Melba23 Amended title Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted July 18, 2014 Moderators Share Posted July 18, 2014 pradisdeep,Welcome to the AutoIt forums. We prefer people not to necro-post in 6 year old threads. Much better to open a new thread and link to the old one. We ask you to do this for two main reasons: - 1. The language advances and the functionality might well be included in core or UDF code by now- 2. The changes in language syntax mean that it is likely that code from more than a couple of years ago may well not run under the current release interpreter without significant modification.And as there is now a very good Excel UDF in AutoIt I am sure you will be able to do what you want to do much more easily using that then depending on send & Mouseclick. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
water Posted July 18, 2014 Share Posted July 18, 2014 (edited) As Melba noted it is (most of the time) better to use the API provided by the program you try to automate than to automate the GUI using Send etc. So please have a look at the Excel UDF and don't hesitate to ask if something is unclear Edited July 18, 2014 by water 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...
Moderators Melba23 Posted July 18, 2014 Moderators Share Posted July 18, 2014 water,Good evening. I thought the new thread title might attract your attention! M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
water Posted July 18, 2014 Share Posted July 18, 2014 That's correct, Melba. As always 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...
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