how to fill web form trough excel Data

[balu7979]

My Name is Balu

in my offilce i do every time Copy the (42rows) excel data to paste website form fields

This is the Web site Image

This is the Excel Data sheet

 

[Margild8a]

Balu7979,

for what understand you need to transfer the data from excel to the web form on a daily basis?

do you know if the web form has HTML tags for each field? if you don't know how to verify this, do the following.

1. Open the form on Internet Explorer
2. Once the form is open type the F12 key
3. In the DOM explorer window click the 'Select element' icon

4. Click one of the fields you enter the data from excel.

Please send a screenshot of the source code for that field from the DOM explorer to know if there is not an applet or if is an HTML form.

regards

 

[balu7979]

Margild8a
Thank u Sir

After I tried I will Tell u (Screen Shots)

thank u

 

[balu7979]

 

[Margild8a]

balu7979,

Do you know how to program an excel macro?

if you do, you may want to check this site, Scraping a website's HTML in VBA

in there explains pretty good how to work with HTML tags and vba, this may give you an idea on how to make a macro to export the data from your excel file to the web form you need to fill.

let me know if you have doubts with this.

regards

 

[balu7979]

balu7979,

Do you know how to program an excel macro?

if you do, you may want to check this site, Scraping a website's HTML in VBA

in there explains pretty good how to work with HTML tags and vba, this may give you an idea on how to make a macro to export the data from your excel file to the web form you need to fill.

let me know if you have doubts with this.

regards

I don't Know how to write program an excel macro

 

[balu7979]

can you explain or you can write a program to (my excel data to web page auto fill)

 

[Kyle123]

No, if you don't know VBA and we cannot access the website then we cannot help you.

 

[balu7979]

i dont know the web site who running, i have a job (10,000Rs indian rupees) in my office copy the excel data to paste to the website total 3000 forms (Any Easy Method)