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
Input Data to Webpage 1
SQL data from VBA - Sort into groups via heading. 7
Using Data Import with URLs and Pointers 2
Import data from excel 1
Extract data from website code. 4
Extract Text in braquet and list of terms from 2 Docs 3

Top