Mithrandir Posted October 12, 2009 Share Posted October 12, 2009 (edited) I'm trying to create a script that read the cells from an excel file and enter the content of them in a web form. The doubts I have are: 1) I want to enter data which are in different columns separated by a space and what I did was to put a blank column and then when filling in the form join the variables with which I read every column. I do not know if have to define a new variable that is the union of the variables with which I read every column and then fill out the form with that variable. 2) I want to reconnect to the Internet after each web form submit. I made a macro using the mouseless browsing plugin for firefox (I have dynamic ip and router) but I have to leave time to wait for a new ip. Are there any command or macro to reconnect to the internet in autoit? 3) Is there a command to check there is internet connection in order to continue the execution of the script (I thought of an If but what I want is to wait until there is connection)? Here It is the code (the web is a random blogger example blogger, I already know how to submit the form and all that) expandcollapse popup#include <IE.au3> #include <Excel.au3> $oIE = _IECreate ("http://www.blogger.com/post-create.g?blogID=*******") $sFilePath1 = "C:\Documents and Settings\Pablo\Mis documentos\Libro1.xls" $oExcel = _ExcelBookOpen($sFilePath1) For $i = 1 To 3 ;Loop $sCellValue = _ExcelReadCell($oExcel, $i, 1);cell with text $sCellValue2 = _ExcelReadCell($oExcel, $i, 2);cell in blank in order to have an space $sCellValue3 = _ExcelReadCell($oExcel, $i, 3);cell with text _ExcelReadCell($oExcel, $i, 1) _ExcelReadCell($oExcel, $i, 2) _ExcelReadCell($oExcel, $i, 3) $oForm = _IEFormGetCollection ($oIE, 0) $oQuery = _IEFormElementGetCollection ($oForm, 6) _IEFormElementSetValue ($oQuery, $sCellValue&$sCellValue2&$sCellValue3);I join $sCellValue (text) with $sCellValue2 (blank space) with $sCellValue3 (text). Can I do this? _IEFormSubmit ($oForm) Run("C:\Documents and Settings\Pablo\Mis documentos\reconectador del router2.exe");this is the macro that reconnects to internet. Sleep(240000) _IENavigate($oIE,"http://www.blogger.com/post-create.g?blogID=*******") Next Thanks for your help! Edited October 12, 2009 by Mithrandir Help with SOAP message!! 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