Quicker External Data From Website into Excel single worksheet Help

Wow great exactly what I needed. Thanks so much man!! Is this difficult?? Does it involved a lot of steps can you guide me through the steps I would like to try to create this same exact thing myself?

If you hit F11 and select the Module1 tab, you will see the code behind the button.

To get a feel of how it is working, click anywhere inside the top subroutine (called Process) and press F8 on your keyboard. You will see a yellow highlighted line. Pressing F8 again will advance the code one line at a time. Use the mouse to hover over the variables (such as N, M, MyYear, MyWeek) to see how their values are changing as the code progresses. If you arrange the windows so that you can see the sheet in the background, you will see the data gradually build up.

The code is effectively a loop within a loop. Everytime the inner loop executes, a call is made to the second subroutine (Called GetScore) which gets the data from the web by constructing a URL containing the year and week number.

Hope this helps.

Thanks!! I see that the code you wrote is visual basic code ?? Any good site to understand visual basic?? Maybe if I understand the basics I would understand the code better.

This is VBA code which is a derivative of Visual Basic.

In order to get started, I would suggest posting to the New Users part of this site to ask folk what they are currently finding useful in ascending the steepest part of the learning curve. The books that I learnt from will be very out of date.

where do i put this code at?? can i put it into a button where you can click??

Nice Thanks!! How do you build the button?? And how I check the code inside the button it won't let me right-click.

Can this code be customized to download data from this website ??

ttp://economictimes.indiatimes.com/infosys-ltd/quarterly/companyid-10960.cms

ttp://economictimes.indiatimes.com/coal-india-ltd/quarterly/companyid-11822.cms

I want to download data for few 100 companies .. i will make a list of company names and companyid's in two columns .. can a Macro pick these two fields generate an url and download the table into excel??

Please help ..

p.s. I have deleted the "h" from the start of link ..

the webquery_snb is copying stuff but not copying the correct data from the site that it is suppose to copy when clicking on start retrieving data dialog box. how to see the code in the dialog box??