Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to create macro that will take data from an Excel sheet and
use it to populate a form on a webpage in IE? I currently manually key information from a table in Excel into a form on a webpage in IE. Each row on the table represents a unique submission to the webpage. Can anyone help me write a macro that will write the data from the first row to the form, "click" submit, write the data from the second row, "click" submit, etc.? Some of the entry is clicking on the appropriate radio button. If this isn't readily accomplished does anyone have any suggestions on how to streamline/automate this process? About 90% of the time only 1 field on the web form is different while ~15 fields are unchanged. Unfortunately the page doesn't "remember" the last submission and won't recall the previous entry so I end up keying all ~16 fields for every submission even when only 1 field changes. I have limited VBA experience but if one of you helpful and talented experts can provide at least the shell of some code i have always been able to make it work in the past. Thanks very much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate form from row data | Excel Programming | |||
Populate form from row data | Excel Programming | |||
populate form from where the cursor is | Excel Worksheet Functions | |||
Populate a form | Excel Worksheet Functions | |||
VB Form to populate spreadsheet. | Excel Programming |