Pull web data to excel

[sujittalukder]

Please refer to a post at this forum http://www.excelforum.com/showthread.php?t=608816

This code downloads data very well from the google finance. When I am using the same from the rediffmail.com with slight variation to the code to suit the address but that is not pulling the data. I think the code needs some more changes. As I am unable to do it, could someone please help me in this.

The modified code for rediff is given below (original code I am not repeating as the same is available in the above linked post)

Please Login or Register  to view this content.

THe url for quarterly results is http://money.rediff.com/money/jsp/co...yCode=15510002

and the url for balance sheet is http://money.rediff.com/money/jsp/ba...yCode=15510002

[sujittalukder]

I think ,odification is needed in table line ie [WebTables = "2,3"] etc. Can someone please help me on how to count the table in a website & what is 2,3? Is this row,column or something else.

I tried many combinations of table no but failed.

[sujittalukder]

Since not getting any reply so posted here http://vbaexpress.com/forum/showthre...748#post108748

[T-J]

From VB Help

WebTables Property - a comma-delimited list of table names or table index numbers when you import a Web page into a query table.

Please Login or Register  to view this content.

imports data from the second and third tables in the web page.

To find out which table number(s) you require, examine the HTML source code of the web page and count the <TABLE> </TABLE> tag pairs.

For http://money.rediff.com/money/jsp/co...yCode=15510002
try

Please Login or Register  to view this content.

hth