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