VBA code to extract data from Wikipedia

Hi

I have a Macro which extracts various suppliers data from Wikipedia
This macro runs using the inspect element code from web

While executing the code for various suppliers I am getting incorrect data

Please Login or Register  to view this content.

Ex. I have inspect element code (td)(9) to extract data for website in wike for Genpact. But Infosys (td) (9) is products

I have enclosed the screen shots and a sample file for your perusal…

Kindly advise

Hi Taps,

Its working fine....great....But I have a question here

I have alot of suppliers whom I need to run against wiki everyday...will this code work for them too?

Thank you

Regards
Kiran Kumar

Hi Kiran,

It will work but for once you have to add a line like below..

Please Login or Register  to view this content.

Regards
taps

Taps... the problem is I have thousands of suppliers... I cant go for every supplier and fetch that information... and the supplier list keep changing from month to month....

request you to please look into the enclosed word doc above...that will make my view clear...

Kindly help

Hi,

Is there any code through which we can identify the table (where the list of data are present) ? as you have identified the each eliment by "td".

regards
taps

Hi Kiran,

See the final solution (hopufully)

Please Login or Register  to view this content.

Regards
taps


Note: If it is working for you then marked the thread as SOLVED
and put some reputation

Hi Taps

Thanks for continuous help... "td" is extracted from Html code for that site... "To view the HTML code... right click on the website and click on Inspect element".... is there a way where we can use "ClasS" tag from HTML code and use Case function to get more accurate data....


Thank you

Regards
Kiran Kumar