Anyone know how to Automatically transfer CSV data to Web page forms?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jcnone@none.com - 28 Jan 2008 01:01 GMT

How can you populate a form fields on a html web page (client side)
with data from an Excel file (CSV). The web page has several text
fields for input that I manually populate. I would like to transfer
the data into the web form automatically from the CSV file. How can
this be done?
TIA
Jman

--
--------------------------------- --- -- -
Posted with NewsLeecher v3.7 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Reply to this Message

Earl Kiosterud - 29 Jan 2008 16:02 GMT

Jman,

I had some success using the SendKeys method in VBA. It wasn't a web form -- it was a
terminal emulator -- but I think I did try it filling out web forms, as well as other
programs (email client, etc.). It worked pretty reliably. It seems like a grunt approach,
but it did work, and it's still in use.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------

> How can you populate a form fields on a html web page (client side)
> with data from an Excel file (CSV). The web page has several text
[quoted text clipped - 9 lines]
> Web @ http://www.newsleecher.com/?usenet
> ------------------- ----- ---- -- -

Reply to this Message