i need to be able to take my excel spreadsheet and upload the info to a web form on the internet. is this possible?

i need it for thousands of users. im trying to propagate the DB via the internet form.

Probably possible assuming that the form is fairly straightforward and doesn't have features designed to prevent auto fill in, such as typing in characters from a gif.
Steps that need coding:

• Open Excel workbook.
• Locate range
• Open IE
• Begin to loop through rows, assuming each row contains one person's details.
• Navigate IE to page, login if necessary
• Fill in form values
• Submit form
• Process next Excel row

As you can see ther are a lot of bits needed, none of which are too complicated but a lot to learn if not used before. Check Google.groups and other posts here for examples of automating Internet Explorer and Excel via script.


--

Joe (Microsoft MVP - XML)

thanks... and before i go out and start looking. do you know any off the top of your head? and could you or willing to help me?!

tia.

mike