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
------------------- ----- ---- -- -

CSV files are not really excel files, they are just ordinary text files. You
can open CSV just like any other text files and read the data. Each line of
data has multiple fields seperated by commas and a line return at the end of
each line.

I don't know webpages that well, but determine if it is easier to just open
the CSV as text in HTML or open an excel file and copy a range of data.

"jman" wrote:

> 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
> ------------------- ----- ---- -- -
>
>

Google for "IE automation VBA"

Eg:
http://p2p.wrox.com/topic.asp?TOPIC_ID=43120

Tim

"jman" <(E-Mail Removed)> wrote in message
news:UR9nj.8612$(E-Mail Removed)...
> 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
> ------------------- ----- ---- -- -
>