jimmyjmmy

Hi, Thanks to JoHanatCent and Water. Yes ,I mean used cells. Anyway this matter is resolved.

OK thanks. Anyway I just found out that by default, it displayed only the active cells.

Hi, Below it is showing the whole excel sheet. What I want is to display only the active cells. So what perimeters I must put.Thanks _ExcelRangeRead ($oWorkbook,default,default,1,default)

You are right Dale, its in html. Thanks

Hi, How do I have an autoit script to autofill the forms in Ladbrokes new account here http://casino.ladbrokes.com/en. Its in Java I think and I could not use IE developers Tool to see the field IDs etc. Thanks

Thanks valuater, malkey and PsaltyDs. Yes, What I am looking for is ContinueLoop. Thanks

Thanks but what I want is if the regex match, iterate the next while loop, I do not wish to exit the loop.

Hi, What must I do so that if the regexp match, go to the next loop :- while 1 If (StringRegExp ($line,"^\s+$")) Then ; go to the next loop Else msgbox(0,"", "whatever") WEnd

Hi, With regards to the script below, after submitting the form, the scripts did not echo the msgbox. Why is that so? Thanks #include <IE.au3> Dim $oIE = _IECreate ("https://login.yahoo.com/config/login_verify2?.src=www&.intl=sg&.done=http://sg.yahoo.com/") WinWaitActive("Sign in to Yahoo! - Windows Internet Explorer","Sign in to Yahoo") WinSetState ( "Sign in to Yahoo! - Windows Internet Explorer", "Sign in to Yahoo", @SW_MAXIMIZE ) $yahoo_id_form = _IEGetObjByName ($oIE,"username") _IEFormElementSetValue($yahoo_id_form,"your yahoo id") $yahoo_password_form = _IEGetObjByName ($oIE,"passwd") _IEFormElementSetValue($yahoo_password_form,"your password") $oForm = _IEFormGetObjByName ($oIE, "login_form") _IEFormSubmit ($oForm) MsgBox(0,"","forms submitted") _IEQuit ($oIE)

Hi, Can someone explain why the following script produce error even though the whole dir was successfully copied. Thanks ;;;; script ;;;;;;;;;;;;;;;;;;;;;;; DirCopy ("d:\testing","d:\testing2",1) If (@error = 0) Then MsgBox(0,"error","error copying") Exit EndIf

Ok, Thanks. I followed the above and I got it working, Thanks. Can someone explain to me why the script below can fill up the forms in yahoo (when $switch = 0) but not in Ladbrokes ($switch = 1) Thanks ;;;; my script ;;;;;;;;;;;;;;;;; #include <IE.au3> $switch = "1" ; to select either to go Ladbrokes or yahoo If ($switch = "1") Then $sURL = "https://www.ladbrokes.com/lbr_portal?action=go_register&casino_aff=default&system_source=Cas&AFF_ID=&bfmid=&bfid=&SC=&InstantPlay=Lobby&return_url=http://casino.ladbrokes.com/en?LANG=en&system_source_id=OCC_WEB" $oIE = _IECreate($sURL) $firstname = _IEGetObjById($oIE,"fname") _IEFormElementSetValue($firstname, "firstname") Else $sURL = "mail.yahoo.com" $oIE = _IECreate($sURL) $firstname = _IEGetObjById($oIE,"username") _IEFormElementSetValue($firstname, "firstname") EndIf

Hi, I wish to fill up the registration form of ladbrokes.com but I was not successful. Can someone help me. My script below. ;;;;; my not working script;;;;;;;;;;;;; #include <IE.au3> $lad_url = _IECreate("https://www.ladbrokes.com/lbr_portal?action=go_register&casino_aff=default&system_source=Cas&AFF_ID=&bfmid=&bfid=&SC=&InstantPlay=Lobby&return_url=http://casino.ladbrokes.com/en?LANG=en&system_source_id=OCC_WEB") WinWaitActive("Registration page - Windows Internet Explorer","Registration page - Windows Internet Explorer") $firstname_form = _IEGetObjByName ($lad_url, "fname") $firstname_value = "firstname" _IEFormElementSetValue ($firstname_form, $firstname_value )

Thanks,What I want to do is to fill in the forms of a current active page. The url of this page is unkown to me because when I click a link, I was redirected to that page and I need to fill in the forms. So how do I fill in the forms of that page? This is what I have done but it wont work. Lets use yahoo sign-up form as an example. https://edit.yahoo.com/registration?.intl=u...omo=&.last= ;;;;; start of my script that wont work ;;;;;;;;;;;;;;;;;;;;;; #include <IE.au3> $oIE = _IEAttach ("yahoo") $oIE = _IEPropertyGet ($oIE, "locationurl") $firstname_form = _IEGetObjByName ($oIE, "firstname") $firstname_value = "firstname" _IEFormElementSetValue ($firstname_form, $firstname_value ) ;;;;;; the output I got the following error ;;;;;;;;;;;;;;; --> IE.au3 V2.4-0 Warning from function _IEAttach, $_IEStatus_NoMatch --> IE.au3 V2.4-0 Error from function _IEPropertyGet, $_IEStatus_InvalidDataType --> IE.au3 V2.4-0 Error from function _IEGetObjByName, $_IEStatus_InvalidDataType --> IE.au3 V2.4-0 Error from function _IEFormElementSetValue, $_IEStatus_InvalidDataType

Ok, Thanks everyone. Its done now.

Hi, Can someone tell me what must I do so that the script below can click yahoo sign-in button. I have the script below but it wont click the sign-in button. $email_address = "abcdef@yahoo.com" $email_password = '12345678 Dim $oIE = _IECreate ("https://login.yahoo.com/config/login_verify2?.src=www&.intl=sg&.done=http://sg.yahoo.com/") WinSetState ( "Sign in to Yahoo! - Windows Internet Explorer", "", @SW_MAXIMIZE ) $yahoo_email_id_form = _IEGetObjByName ($oIE, "username") $yahoo_email_id_value = $email_address _IEFormElementSetValue ($yahoo_email_id_form, $yahoo_email_id_value) $yahoo_email_password_form = _IEGetObjByName ($oIE, "passwd") $yahoo_email_password_value = $email_password _IEFormElementSetValue ($yahoo_email_password_form, $yahoo_email_password_value) $submit = _IEGetObjByName($oIE, "yreglgsb") _IEAction($submit, "click")