Internet Explorer interaction

Good afternoon all,

I have a webform for my company that we fill in with repetative data from excel, I am trying to populate it automatically but I am rubbish with websites so I have no idea how to get VB to control the form. I have managed to get it to populate the form but I cannot get it to submit the data.

From the page source information I believe I just need it to click the button identified by the following code:

<p><input type="submit" name="submit" class="button" value="Log in" /></p>

Can anyone help?

do you have example sheet?

I can't really give away the website address online as it's probably not very secure, but the code I have is in the early stages and is as follows:

Dim ie As InternetExplorer
Dim C
Dim Value1 As Boolean, ieForm
Dim Value2 As String, MyLogin As String

redo:
Value1= Application.InputBox("Please enter value 1", "Ecaytrade username", Default:="Value1", Type:=2)
Value2 = Application.InputBox("Please enter value 2", "Ecaytrade Password", Default:="Value2", Type:=2)

If Value1 = "" Or Value2= "" Then GoTo redo

Set ie = New InternetExplorer
ie.Visible = True
ie.Navigate "http://website address"

'Loop until ie page is fully loaded
Do Until ie.ReadyState = READYSTATE_COMPLETE
Loop

For Each ieForm In ie.Document.forms
If InStr(ieForm.innertext, "Data Entry") <> 0 Then
ULogin = True
'enter details
ieForm(1).Value = Value1
ieForm(2).Value = Value2
ieForm.submit
Exit For
Else
End If
Next
Set ie = Nothing
End Sub

ieForm.submit is where it fails with runtime error 438.

Try This

Please Login or Register  to view this content.

Sniper - this really did the job! Perfect, thanks!

Please Login or Register  to view this content.

One question... if I fill in the form manually I only have to TAB once after entering the second value, why did you include 2 TABs? (You are obviously correct as I tried with only one and it didn't work, just wondering why?)

it enters the data and then only when you TAB it runs through the fields, we didn't send the tab and entered a value nother tab value and the to submit or log in.