All Activity

This stream auto-updates   

  1. Past hour
  3. I think I found the problem You have two letters set as a hotkey. When the data read from Excel contains an "e" then the Exit hotkey gets triggered. Use keys not contained in the data you send to the other application. The example now uses F1 to start and F4 to exit the script. #include<excel.au3> HotKeySet("{F1}","start") HotKeySet("{F4}","end") Local $oExcel = _Excel_Open() Local $oWorkbook = _Excel_BookOpen($oExcel,"C:\Users\SAHIL\Desktop\l2d\book1.xlsx") Local $aValues = _Excel_RangeRead($oWorkbook) While 1 Sleep(100) WEnd Func start() For $i = 1 To 25 ConsoleWrite("Loop #" & $i & @CRLF) WinActivate("Link2Data") MouseClick("left", 450, 430) Send($aValues[$i-1][0]) ; $_name MouseClick("left", 450, 460) Send($aValues[$i-1][1]) ; $_email Next EndFunc Func end() Exit 0 EndFunc
  4. Will have a look. BTW: There is no need to quote my replies. I know what I have written Simply enter your reply and press the "Submit Reply" button
  5. it still loops only 1 time. I've even tried different loop commands like while and do_until. It always loops only a single time
  6. Can you still connect with Plink to that box (via AutoIt script)? Just cant determine from your post whether the issue is the connection or the command. This code in the link below is how I previously organized my plink commands. The option I chose as of late was to install the linux subsystem feature and use bash, that has been most optimal.
  7. Give this a try: #include<excel.au3> HotKeySet("{s}","start") HotKeySet("{e}","end") Local $oExcel = _Excel_Open() Local $oWorkbook = _Excel_BookOpen($oExcel,"C:\Users\SAHIL\Desktop\l2d\book1.xlsx") Local $aValues = _Excel_RangeRead($oWorkbook) While 1 Sleep(100) WEnd Func start() For $i = 1 To 25 ConsoleWrite("Loop #" & $i & @CRLF) WinActivate("Link2Data") MouseClick("left", 450, 430) Send($aValues[$i-1][0]) ; $_name MouseClick("left", 450, 460) Send($aValues[$i-1][1]) ; $_email Next EndFunc Func end() Exit 0 EndFunc
  8. Today
  9. it's showing that it loops only 1 time. I want it to loop 25 times
  10. I was thinking the same, seems there are some updates that screw some stuff up.
  11. Add some debugging to your script. This way you will see how often it loops: #include<excel.au3> HotKeySet("{s}","start") HotKeySet("{e}","end") Local $oExcel_1= _Excel_Open() Local $oworkbook = _Excel_BookOpen($oExcel_1,"C:\Users\SAHIL\Desktop\l2d\book1.xlsx") While 1 Sleep(1) WEnd Func start() For $i = 1 To 25 ConsoleWrite("Loop #" & $i & @CRLF) Local $_name = _Excel_RangeRead($oworkbook,default,"A" & $i) WinActivate("Link2Data") MouseClick("left",450,430) Send($_name) Local $_email = _Excel_RangeRead($oworkbook,default,"b" & $i) MouseClick("left",450,460) Send($_email) Next EndFunc Func end() Exit 0 EndFunc
  12. Looks like you can do it with the Execute Script feature -- _WDExecuteScript($sSession, '', '{}') Once the tab is created, you will need to switch to it using the correct commands before you can interact with it.
  13. Ok, Thank you very much about your UDF.
  14. Good question. Not sure to be honest. I'll post back if I come up with a good example.
  15. my problem is that i cannot get the script to loop. i am fine with working with screen coordinates as anything else might become too complicated for me
  16. How do I open multi Tab in Chrome? Thank you very much
  17. I suggest to use Control* functions. Working with screen coordinates and Send isn't very reliable. When you use the AutoIt Window Info Tool does it "see" the controls where you want to insert your data?
  18. im trying to make an auto form filling script. Link2data is the app where the forms are.
  19. Thank you Danp2. I'm glad I was able to use it normally after rebooting. Thanks for your answers
  20. My question is: Why do you need Pixelsearch at all? Autoit provides means to directly access a window wherever it may be located on the screen. If you could post a screenshot with all private data made unreadable - would help us to help you!
  21. Currently I'm using the PixelSearch command within a loop, and using WinActivate. My issue is that PixelSearch looks either within - 1. A specified rectangular area based on the pixels of your screen resolution. $rectangular = PixelSearch( 599, 113, 648, 160, 0x78B31B) or 2. The entire desktop. (@DesktopHeight and Width) $full_screen_res = PixelSearch( 0,0, @DesktopHeight, @DesktopWidth, 0x78B31B) BUT I need a way to isolate the PixelSearch to an active Window, and THEN the specified rectangular area within that window, being 1920x1080 in resolution. I don't have a screenshot I can share, but the best information I can provide is that the Window will always be a specific resolution (1920x1080), because I'm going to build it that way. If it simplifies the question, I want PixelSearch to search within a specific Window, not my entire desktop resolution. I'm confident this is do-able, but I'm far too new to coding to understand exactly what to search for when self-educating. I know the PixelSearch command itself cannot specify a Window, so I would need to specify this within the loop. My gut feeling is that this doesn't relate to PixelSearch at all, but instead somehow isolating the script itself to a specific Window?
  22. This is not an error. The code is designed to work that way. When you move items in a listbox with the mouse, you can either drop items above or below the target item. Here it's chosen to drop items above the target item with the consequence that you cannot drop items below last item (only above last item). You could also have chosen to drop items below the target item. Then there would have been a similar problem with the first item. Solution. Drop your item just above the last item. Move the last item one item up.
  23. I would like to know on how to login using PowerShell, and what wrong is following coding? Does anyone have any suggestions? Thanks in advance for any suggestions HTML Coding <form id="form-login" action="/login/" method="post"> <input type="hidden" value="aaabbbcccjfheh48u8jdjd" name="FORM_TOKEN" /> <input type="hidden" name="referer" value=""> <label class="mts txtRight col1 required" for="LoginForm_email">E-Mail <span class="required">*</span></label> <input class="ui-inputText" name="LoginForm" id="LoginForm_email" type="email" /> <label class="mts txtRight col1 required" for="LoginForm_password">Password <span class="required">*</span></label> <div class="collection col2"> <input class="ui-inputPassword ui-inputPassword" name="LoginForm[password]" id="LoginForm_password" type="password" /> <button class="ui-button ui-buttonCta" type="submit"> PowerShell Script $clnt = new-object System.Net.WebClient $URL = "" $token = "aaabbbcccjfheh48u8jdjd" $username = "sample_username" $password = "sample_password" $postParams = @{FORM_TOKEN=$token; LoginForm_email=$username; LoginForm_password=$password} Invoke-WebRequest -URi $URL -Method POST -body $postParams
  24. @NguyenLe Please let me know if you did the follow as previously requested.
  25. Google is your friend when you need to find this type of information.
  26. Why can't you directly access the window using window title and window text? Can you post a screenshot of this window?
  1. Load more activity