Populate Webpage field with Excel VBA MSXML2.XMLHTTP

Question

I am very new to VBA programming and spending lots of time learning this. Recently, I am trying to learn MSXML2.XMLHTTP- how to get data from a webpage and how to input data from excel into the webpage field.

To do so, I am trying to Create a new Facebook account using XML and not IE or an HTTP request with Excel VBA. I consider opening Facebook account, because here I can learn how to handle all types of control (text field, dropdown, Radio button, submit button)

Values will be taken from an excel sheet and populate the webpage:-
• First name is in Cell ("A1")

• Last name is in Cell ("A2")

• Mail ID is in Cell ("A3")

• Password is in Cell ("A4")

• Date of Birth is in Cell ("A5"). A big challenge to select values from the dropdown.

• Gender is in Cell ("A6")

• need to click the button "Sign up"

Really appreciate your help to enrich my coding knowledge.

Answer 1

Intéressée

Answer 2

@John Korchok Actually I am stuck in coding writing. I don't know how to write this code.

Sub PopulateFBAccount()

Dim s$
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", "https://www.Facebook.com", False
.send
s = .responseText
End With

Dim htmlF As Object
Set htmlF = CreateObject("htmlfile")

........................................................... 'No idea how to approach.
...........................................................
...........................................................
...........................................................

End sub