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
- ontidListTitle -(text field)
- ontidListDescription -(text field)
- ontidDisplayOnLeftNo -(radio button)
- ontidShowUserNameYes -(radio button)
- ontidAllowMultipleVoteNo -(radio button)
- 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