Filling out online html forms using VB

Hello, we have an excel spreadsheet that does pretty much what you are suggesting developing. I have posted some sample code for you to take a look at/play with to see if it suits your needs. Basically you use the Internet Explorer object in Excel (not sure what Add In is required) and then you just navigate to a chosen location.

From ie8 onwards then there are a lot of internet explorer page elements that are 'protected' from this type of automation (stopping you from firing off values to populate them automatically) and depending on how the webpage you want to manipulate has been developed (right click on it and view source) then this approach may not be possible at all - this only works on webpages that have been built up with distinct individual 'elements' and not a single javascript lump or window but for basic stuff then I think something along these lines should suffice...

Sub BlahBlahBlah

Dim ie As Internet Explorer
Dim elephant as object

Application.StatusBar = "Logging into webpage"

Set ie = New InternetExplorer
ie.Visible = True
ie.Navigate "" & Worksheets("Working").Range("URL1") & ""

Do Until ie.Busy = False
Loop

'Signs In
ie.Document.all("UserName").Value = "" & Worksheets("Working").Range("USERNAME") & ""

ie.Document.all("Password").Value = "" & Worksheets("Working").Range("PASSWORD") & ""

ie.Document.all("txtProduct").Value = 5

'presses login
For Each Elephant In ie.Document.all
If Elephant.className = "button" Then
If Elephant.nameProp = "btn_login.gif" Then
Elephant.Click
End If
End If
Next Elephant

Do Until ie.Busy = False
Loop

Application.StatusBar = "Tidying up..."

ie.Quit
Set ie = Nothing

End Sub