how to get data from online data base.

[mahaveer]

Actually i have a list of dealer with their TIN Number But i need to Verify these TIN Number on this website that is : http://rajtax.gov.in/vatweb/rightMenu.do


so problem is this it takes so much time so i need a vba code with loop so that Name of dealer will show automatically in next column to their tin number.

I am attaching a sample excel file.


Any help much appreciated.


Thanks & Regards
CA Mahaveer Somani

 

[Hui]

Mahaveer

I have tried to manually access the web site listed above and get an

Unable to Retrieve this Page

Error ?

On the http://rajtax.gov.in/vatweb site there is no where to enter the data

Does it require login information ?

 

[sgmpatnaik]

It is a Rajasthan Commercial Tax Department Site and here it must need to login

http://www.rajtax.gov.in:7777/vatweb/

after that we can do any thing

 

[vrunda]

Mahaveer,

Refer to this , hope it helps u:
http://chandoo.org/forum/threads/get-reg-nos-from-a-website.7614/

 

[mahaveer]

thanks for your quick response but i extreamly sorry sir, there was error in the above link so i m posting another link which is working. ie. http://rajtax.gov.in/vatweb/dealer/dealerMain.jsp?viewPageNo=13

and sir there is no need to log in this site we can get dealer search without log in.


So please help me thanks again all of your Sir.

 

[mahaveer]

in the above site each time

SEARCH BY = TIN
DEALER TYPE = VAT
ENTER THE SEARCH CRITERIA = IT WILL BE LIST OF TIN NUMBER WHICH I PROVIDED IN MY EXCEL SHEET.

 

[Marc L]

Here is the Excel formulas forum …

See threads in the right forum VBA Macros …
​

 

[Somendra Misra]

Contd. at

http://chandoo.org/forum/threads/how-to-get-data-from-online-data-base.18123/

Regards,