dimanche 22 octobre 2017

Excel VBA Fill-out form, submit then repeat until condition is met

I'm trying to create a button that will allow the Excel data be transferred into a Web Form. The button shall transfer the Title, click a radio button, submit then copy the generated link into a cell, after that it should iterate until all data from excel is done.

For now all I have is this code that will open the Website and Chrome.

Sub create_survey()

Dim chromePath As String

chromePath = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"""

Shell (chromePath & " -url http://)

End Sub

Below are the field name tags for the HTML

  1. ontidListTitle -(text field)
  2. ontidListDescription -(text field)
  3. ontidDisplayOnLeftNo -(radio button)
  4. ontidShowUserNameYes -(radio button)
  5. ontidAllowMultipleVoteNo -(radio button)
  6. ct100$PlaceHolderMain$ontidCreateSurvey -(submit button)

Due to some restrictions I will not be able to use 3rd party program or extension.

Aucun commentaire:

Enregistrer un commentaire