Populate Webpage field with Excel VBA MSXML2.XMLHTTP

Mohashin Bhyian 1 Reputation point
2022-10-23T18:01:05.283+00:00

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.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
{count} votes

2 answers

Sort by: Most helpful
  1. EMNA NAJI 1 Reputation point
    2022-10-23T20:41:40.33+00:00

    Intéressée

    0 comments No comments

  2. Mohashin Bhyian 1 Reputation point
    2022-10-24T03:09:38.687+00:00

    @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

    0 comments No comments