Re: Pulling Data from Web Automatically

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Normally, I would be able to use something like this but I get "unable to open"

Sub GetData()
With Active***.QueryTables.Add(Connection:= _
"URL;http://incometaxindiaefiling.gov.in/knowtan/knowtanresults.jsp?curpage=11";, _
Destination:=Range("A4"))
.BackgroundQuery = True
.SaveData = True
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingNone
.Refresh BackgroundQuery:=False
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
<kanwalno1@xxxxxxxxx> wrote in message news:ee63e030-bddb-4372-8eab-dc1ce10a0525@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All,

I am trying to gather data from web into excel. The problem is like
this.
1. http://incometaxindiaefiling.gov.in/knowtan/knowtan.jsp is address
of web site where you can search TAN data for the assesses using
search criteria, if you know the TAN.
2. If you select only the "Category of Deductor" and/or "State"
without mentioning anything in 3rd search criteria, it will give
results for the whole database by clubbing 10 results per page
(alongwith the page number links for further search)
3. Each link on the result page leads us to "Particulars" of that
link, which is the desired information I need.

Is there any way by which the particulars for each link on each page
are pulled/imported into one excel ***/workbook (in columner form)
automatically, thereby avoiding the need to open each link and copying
the results to excel *** again and again.

Kind Regards
CA Kanwaljit Singh Dhunna
India

.

Quantcast