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