getting data from website's url and webpage

  • Thread starter sandip.dhamapurkar
  • Start date
S

sandip.dhamapurkar

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/company.jsp?companyCode=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
 
T

Tim Williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Understanding and comparing stock market figures 10
Need help with macro 12
Stuck at Trying to Extract Data from a Website using JSP 16
Getting Data from Web - where the URL is the value of the active c 3
code to extract data from a website runs of XP but not Vista 1
data splitting 4
Getting data from a worksheet 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2

Top