ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   getting data from website's url and webpage (https://www.excelbanter.com/excel-programming/405847-getting-data-websites-url-webpage.html)

[email protected]

getting data from website's url and webpage
 
Hello,

I have few codes in column C. Here is how I do my job manually. I go
to a website http://money.rediff.com/money/jsp/co...yCode=14030055
and in the searchbox I type my first code in cell C1 which is 532628
and press the Go button.

From here, I extract the company name 3i Infotech Ltd. and put it in
A1, then I take the company code 13190098 from its url and put it in
B1.

Is there an automated way to do it? I tried using webquery but don't
know how to supply my code numbers in column C

Can anybody help?

Example codes:
532628
523395
524412
532937
532774
530513
532762
532840
532811

Thanx
Sandy

Tim Williams

getting data from website's url and webpage
 
No point bumping and not bothering to include the original question - I for
one will not bother to switch views just to see the OP.

Tim


wrote in message
...
bump





All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com