Hello, what I'd like to do is extract a list of movies from http://www.icheckmovies.com/profile/checked/icmdsb/
and paste it into a single worksheet.
The complete list, however, is split up into hyperlinked numbered pages like
http://www.icheckmovies.com/profile/...icmdsb/page+2/
and requires you to click through to fully access the list.
I'd like the VBA to look at the url on the worksheet, determine from the html the max pages in the list and then iterate though and extract it (full html formatting) to a single worksheet.
Thanks for taking a look!
Bookmarks