Excel Macro to fill a web form

August 3, 2011 at 19:18:17
Specs: Windows XP
Hi -

I'm in need of some help... I'm trying to autofill a form on a webpage with fields from an excel sheet. Anyone have examples I can use?

Example: My excel sheet will have: First, Last, Birthday, Address, Zip, etc... in each cell A1, A2, A3, etc...

I will add 10 - 20 users information, and with the click of a button, transfer each field data to the web form.... It doesn't need to do all 10 - 20 users in a loop. I want to just select the first user, click the button and all the info for that user gets transferred.

Any examples would help. Thanks.

See More: Excel Macro to fill a web form

Report •

August 4, 2011 at 06:17:52
Pretty much impossible to do without knowing the DOM of the page.
The other, better, way involves making your own HTTP query to send your data, bypassing the GUI aspects of the web browser altogether, but this is pretty much impossible without know what fields the server expects. (It's also a great way to check the competency of the systems designer, and see if the server does any validation on its side.)

How To Ask Questions The Smart Way

Report •
Related Solutions

Ask Question