Retrieving data from website

[arbit.address]

Dear Friends,

I need to fill a form field of a website repeatedly with different values(10,000 such values) and then get the corresponding results. How can I perform such an operation using excel?

Thanks

 

[mole999]

you'll need to provide more that just the idea to be able to get proper help

webpage, data types, actions etc

a number of automations have been discussed on here recently

 

[arbit.address]

The webpage is

http://passportstatus.nic.in/passmain.php?city=bpl

I need to retrieve the results by entering the file reference no. (seven characters say A001000, A001001, A002001 etc.) and then clicking teh "SUBMIT" button.

Thanks

 

[mole999]

10,000 passport application checks on a Government web site !

looking at the return, its incorporated into the page in header tags, so i'm not sure how it will abstracted

 

[arbit.address]

all that because i forgot my passport application number. The other option is to bribe the officials or stand in the government queue for ages negotiating the great indian bureaucracy.