Uisng VBA to interact with Web

[PaulSpell]

Hello, I've been writing some code to pull data from a website and have hit a bit of a problem. I'd be grateful if someone could help with help this.

The one thing that I can't seem to do is to set the value of a combo box on the webpage. I need to select a value in order for the correct results to show, which I then copy into my database.

Does anyone have any code I could use to set the value of a combo box on a web page?

 

[spikepl]

I have an Access-application with stuff like this:

    HTMLDoc.getElementById("MainContent_NameTextBox").Value = WebUserName
    HTMLDoc.getElementById("MainContent_DropDownList_Organization").Value = WebCustomerName
    HTMLDoc.getElementById("MainContent_DropDownList_Roles").Value = Role
    HTMLDoc.getElementById("MainContent_Email").Value = WebUserEmail
    HTMLDoc.getElementById("MainContent_Mobile").Value = WebUserMobile
    HTMLDoc.getElementById("MainContent_Checkbox_SendSmsCode").Checked = SMScode
    HTMLDoc.getElementById("MainContent_CreateUserButton").Click