NelsonJah Posted June 7, 2023 Share Posted June 7, 2023 i need help, Clear text found in TextBoxY from WindowX and Input text into TextBoxY by Reading the list line-by-line (per macro repetition/loop) found in "@Username" (current windows user name) column in csv/exel file. (In short, each loop, clears and inputs line-by-line from "@Username" column to TextBoxY) (Number of loops = read 1st row found in "@Username Count" column) + PM looking for AutoIT coder Link to comment Share on other sites More sharing options...
NelsonJah Posted June 7, 2023 Author Share Posted June 7, 2023 Its a custom App running on a network, doesn't run if send it u so i described the process like below: (1) Run the program from custom path and Wait till WindowA gets active(2) Activate Button1 from WindowA (without mouse click) and wait till WindowB gets active(3) Clear text found in TextBox1 from WindowB and Input text into TextBox1 by Reading the list line-by-line (per macro repetition/loop) found in "@Username" (current windows user name) column in excel file. (In short, each loop, clears and inputs line-by-line from "@Username" column to TextBox1) (Number of loops = number of rows found in "@Username" column or Read count found in TotalCount value in "@Username" column)(4) Activate Button2 (without mouse click) from WindowB(5) Wait till WindowC gets active and Activate Button3 from WindowC (without mouse click) and Loop from (3) and if WindowC is not found, Copy the last input TextBox1 text and Send it to Email + Write to Excel in "@Username Not Found" column Here below provide all required Titles, Text, Class, Instances, IDs, etc for Windows and Buttons.WindowA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>> Window <<<< Title: Select Class: WindowsForms10.Window.8.app.0.297b065 Position: 600, 381 Size: 400, 138 Style: 0x16C80000 ExStyle: 0x00050101 Handle: 0x0000000000040F2E >>>> Control <<<< Class: WindowsForms10.STATIC.app.0.297b065 Instance: 1 ClassnameNN: WindowsForms10.STATIC.app.0.297b0651 Name: Advanced (Class): [CLASS:WindowsForms10.STATIC.app.0.297b065; INSTANCE:1] ID: 1773418 Text: Welcome *********************************************** WindowB - TexBox ~~~~~~~~~~~~~~~~ >>>> Window <<<< Title: Enter data Class: WindowsForms10.Window.8.app.0.297b065 Position: 502, 292 Size: 595, 316 Style: 0x16C80000 ExStyle: 0x00010101 Handle: 0x0000000000210E46 >>>> Control <<<< Class: WindowsForms10.EDIT.app.0.297b065 Instance: 4 ClassnameNN: WindowsForms10.EDIT.app.0.297b0654 Name: Advanced (Class): [CLASS:WindowsForms10.EDIT.app.0.297b065; INSTANCE:4] ID: 2297436 *********************************************** WindowB - Activate Button2 ~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>> Window <<<< Title: Enter data Class: WindowsForms10.Window.8.app.0.297b065 Position: 502, 292 Size: 595, 316 Style: 0x16C80000 ExStyle: 0x00010101 Handle: 0x0000000000040FE6 >>>> Control <<<< Class: WindowsForms10.BUTTON.app.0.297b065 Instance: 2 ClassnameNN: WindowsForms10.BUTTON.app.0.297b0652 Name: Advanced (Class): [CLASS:WindowsForms10.BUTTON.app.0.297b065; INSTANCE:2] ID: 200714 Text: Activate ************************************************** WindowC - Activate Button3 ~~~~~~~~~~~~~~~~~~~~~~~~~~ >>>> Window <<<< Title: OK Class: #32770 Position: 620, 401 Size: 366, 149 Style: 0x94C801C5 ExStyle: 0x00010101 Handle: 0x0000000000260814 >>>> Control <<<< Class: Button Instance: 1 ClassnameNN: Button1 Name: Advanced (Class): [CLASS:Button; INSTANCE:1] ID: 2 Text: OK Link to comment Share on other sites More sharing options...
argumentum Posted June 7, 2023 Share Posted June 7, 2023 6 minutes ago, NelsonJah said: hey!i am new user for the forum and newbie for autoIt.since i don't know anyone, i ve got ur contact from forum online users asking u kindly. ... ..well, don't send direct mail to users of the forum. As far as moneys, I have no interest and will help those I feel I can, if they show effort to learn. Again, don't DM users you don't personally know well enough to have that type of comunication. Aelc 1 Follow the link to my code contribution ( and other things too ). FAQ - Please Read Before Posting. Link to comment Share on other sites More sharing options...
NelsonJah Posted June 7, 2023 Author Share Posted June 7, 2023 28 minutes ago, argumentum said: ..well, don't send direct mail to users of the forum. As far as moneys, I have no interest and will help those I feel I can, if they show effort to learn. Again, don't DM users you don't personally know well enough to have that type of comunication. lesson learned! accept my sincere apology...i am ready and would be so happy to learn! Link to comment Share on other sites More sharing options...
spudw2k Posted June 7, 2023 Share Posted June 7, 2023 Based on the process you have laid out, seems reasonable/doable. Have you written any code yet, and if so, can you share it? Can you also tell us where in the process you are getting stuck/unsure how to script and we'll try to point you in the right direction. Bonus pro forum tip: when you post code in a forum thread, use the <> button in the toolbar, to the right of the Bold, Italic, Underline, Strikethrough buttons. Spoiler Things I've Made: Always On Top Tool ◊ AU History ◊ Deck of Cards ◊ HideIt ◊ ICU ◊ Icon Freezer ◊ Ipod Ejector ◊ Junos Configuration Explorer ◊ Link Downloader ◊ MD5 Folder Enumerator ◊ PassGen ◊ Ping Tool ◊ Quick NIC ◊ Read OCR ◊ RemoteIT ◊ SchTasksGui ◊ SpyCam ◊ System Scan Report Tool ◊ System UpTime ◊ Transparency Machine ◊ VMWare ESX Builder Misc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retrieve SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose Array Projects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalc Cool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted June 7, 2023 Moderators Share Posted June 7, 2023 Moved to the appropriate AutoIt General Help and Support forum, as the Developer General Discussion forum very clearly states: Quote General development and scripting discussions. Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums. Moderation Team 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...
Recommended Posts