I have some URLs (listed in a text file), For each URL listed, I want a particular block of HTML data as shown in attached file (highlighted) to be retrived from the source HTML file of the URL and parsed it to the following format and stored in an excel file in the order as retrived.
One URL: http://www.actfind.com/categories/wholesale-Laptop-Notebook/?page=2&sort=featured
Attached document shows the HTML source for the above URL. I have highlighted in YELLOW the block of HTML to retain after truncating the other things out.
From this block of HTML code, i need the following to be stored into excel sheet in the respective columns.
1. img src eg: 'http://www.actfind.com/product_images/o/pcnb1015__15534_thumb.jpg'
2. product name
Separate excel sheets for each URL in the list please. VBA code is preferred for ease of my understanding please.