Jump to content

Tyw214

Members
  • Posts

    9
  • Joined

  • Last visited

Tyw214's Achievements

Seeker

Seeker (1/7)

0

Reputation

  1. Basically, i have a script that sums a bunch of number using different functions, and it sometimes can take up to 15-20 seconds to finish. At the end, a msgbox pops up to tell the user the total, but is there some kind of thing that I can add during that 15-20 seconds while its running to tell the user that it's "working" and not like just doing nothing/frozen? Thanks!
  2. How does the byIndex work? Is it index'd from the top of the form? Or index'd by the element defined by the 'pv___5_30'?
  3. Ah... so can't use that function altogether lol... seems kind of defeat the purpose ;p
  4. HTML <form name="variations"> <input type="checkbox" name="pv__5_30" id="id_pv__5_30" /> </form> How do you check that box?
  5. Ok. Cool I have everything working EXCEPT I can't stop the loop Here is my code #include <Excel.au3> #include <File.au3> #include <IE.au3> Local $sFilePath = "C:UsersDocumentstest.xlsx" _ExcelBookOpen($sFilePath) $oExcel = _ExcelBookAttach($sFilePath) For $i=1 to 7 $a = _ExcelReadCell($oExcel, $i, 1) For $j=1 to 7 $b = _ExcelReadCell($oExcel, $j, 2) For $k=1 to 7 $c = _ExcelReadCell($oExcel, $k, 4) For $l=1 to 7 $d = _ExcelReadCell($oExcel, $l, 3) For $m=1 to 7 $e = _ExcelReadCell($oExcel, $m, 5) If $a="" Then ExitLoop $sURL = "http://www.example.com/forms" Local $oIE = _IECreate ($sURL) Local $oForm = _IEFormGetObjByName($oIE, "product_form") Local $oSelectBox1 = _IEGetObjByID($oForm, "id_box1") _IEFormElementSetValue($oSelectBox1, $a) Local $oSelectBox2 = _IEGetObjByID($oForm, "id_box2") _IEFormElementSetValue($oSelectBox1, $b) Local $oSelectBox3 = _IEGetObjByID($oForm, "id_box3") _IEFormElementSetValue($oSelectBox1, $c) Local $oSelectBox4 = _IEGetObjByID($oForm, "id_box4") _IEFormElementSetValue($oSelectBox1, $d) Local $oSelectBox5 = _IEGetObjByID($oForm, "id_box5") _IEFormElementSetValue($oSelectBox1, $e) Next Next Next Next Next Need help stopping the loop after creating the 7 window ... right now it's looping back to 1 >_>
  6. my concern is just I can have 2 #include right? Do i put them right at the top in the first 2 row of my script?
  7. Is this possible? I've finished grabbing all the Obj in IE correctly, but I need a way to copy contents in an excel to specific text box in an IE Form. This is the script I have so far for IE: #include <IE.au3> $sURL = "http://www.example.com" Local $oIE = _IECreate ($sURL) Local $oForm = _IEFormGetObjByName($oIE, "product_form") Local $oSelectAttrVal = _IEGetObjById($oForm, "id_productattribute_set-0-value") _IEFormElementSetValue($oSelectAttrVal, "") ;; Text Box Identifier I am able to just enter a string and have that text box filled, but I would like to basically do this following: Create 10 x (loop this 10x) IE Window and enter into that Text Box (each instance different text) from Excel's Cell A1 to A10 into the 10 different IE Forms. Like A1 will be copied into the first IE Form, A10 will be copied into the 10th IE Form. Or alternatively, if it's easier to code/script, from a plain text file Line 1 to Line 10. Thanks in advance.
  8. I am a newbie to writing script, i've only dabbled with jQuery and html/css (which I find them easy enough for me to understand to get what I need done), but I am having an incredibly difficult time understanding the Autoit syntax/commands. What I am trying to achieve sounds very simple but trying to write it in autoit script is pure frustration. I basically need to select an option on a webpage with url: www.example.com <select name="Options" id="id_Options"> <option value="" selected="selected">---------</option> <option value="1">Option 1</option> <option value="2">Option 2</option> I know the best way for me to do this is probably using the _IEFormElementOptionSelect But I am stumped at the example which also seem to require me to do use _IEFormGetObjByName AND _IEFormElementGetObjByName Usually, i'd just look up the syntax for those functions, but the explanation for each of the parameters in the function is incredibly jargon-filled. Not that I don't understand the meaning of it, but I fail to draw a logical connection between the parameters and its use in that specific function.... So can somebody just give me a simple sample script using the html I provided above? And Select an option? This is how far I got... #include <IE.au3> $s_URL = "http://www.myriadsupply.com/admin/product/product/add/" Local $o_IE = IECreate ($s_URL) _IELoadWait ($o_IE)
×
×
  • Create New...