Help with "Excel 2007 Web Data Add-In" Goto next page
All,
I'm attempting to extract data from a website.
I using "Excel 2007 Web Data Add-In"
I'm able to train the add-in on what data to grab but I can't find a method for going to the next page and extracting the data from the following pages.
For example
Using Amazon
http://www.amazon.com/s/ref=sr_nr_sc...a1092232104dc3
I can extract the first 50 song titles but how do I goto the next page and get the next 50
keep looping until there are no more pages?
Thanks
Steve