Do you have a web address you can post so we can try and see if what you
want is doable? If so, can you also tells what cells on your worksheet go to
what fields you are referring to?

--
Rick (MVP - Excel)


"confused" wrote in message
...
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.