I am trying to get website data into an Excel sheet and currently have minimal knowledge of VBA. I found this code in a tutorial and customized it for me and it does work. However it only picks up the information for the last coupon on the page. There are 18 coupons on a page, but approx. 350 all total, I would like to get the data for all of the coupons.
Also for the fourth column, I would like to add the number for the coupon. It is in the source code as
<img width="80" height="100" src="//cdn.cpnscdn.com/insight.coupons.com/COS20/_Cache/_ImageCache/391/18055391.gif"
That source stays consistent with just the number changing, is there anyway to grab that number?
Thanks for any help anyone can provide.
Bookmarks