Scraping Data from a URLs List Into Excel Using VBA

I have a list of several hundred URLs in Excel. The URLs are all from the same site and have the same format and structure, but the specific data on the page varies (example about one URL: http://finance.vietstock.vn/DPM/1/co-dong-lon.htm. I am hopeful that there is a way to do this using VB, but I have not been able to get it to work.

I have successfully used a Web Query for one of the URLs from my list (the link above) into Sheet 2. My workbook have two sheet: Sheet 2 with the result from the above URL and Sheet 1 has the URLs list. Now I need an automated solution that will look up the next URLs in the list, run the Web Query and download new data to new sheets (one sheet for one URL).

Does anyone have any pointers how to do this? Or perhaps a better way to accomplish this than using VB? Thanks for your help!

P/S: This is my file, for your reference.

https://drive.google.com/file/d/0B3g...ew?usp=sharing

Originally Posted by AB33

Where do you get the names of new sheets? I used columns B values, but some of the rows are duplicates, so I can not use the same name. Each name has to be unique. Obviously, the code will be very slow
Try

Hi AB33,

Thank you so much for your reply. I've tried the code and it succeeded. But if I want to combine sheet with the same ticker, for example: ABT1 and ABT2 into 1 sheet (ABT), DPM1 and DPM2 into 1 sheet (DPM). Does that change all the VB code required, or should the initial code you gave me work with a little fitting? Thanks again for your help