-
Sep 29th, 2017, 04:15 AM
#1
Thread Starter
Registered User
autofill web forms using excel vba script
hi,
I am not familiar to VBA and i made this script by referring a video posted by some user.
What i am trying to do is to autofill web forms using cell values from excel.
This is just a sample...if i get this right ill try to do this on actual website.
i got the following error upon execution..Run-Time error '424' : object required.
Need your help!!
CODE:-
Sub automaticformfilling()
Dim ie As Object
Set ie = CreateObject("internetexplorer.application")
With ie
.Visible = True
.navigate "http://formsmarts.com/html-form-example"
'Wait for loading
Do While .busy
DoEvents
Loop
Do While .readystate <> 4
DoEvents
Loop
End With
[ie.document.getelementbyid("u_u9x_4607").Value = Sheets("sheet1").Range("A1").Value[/B] 'This is where i get the error...
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|