+ Reply to Thread
Results 1 to 1 of 1

VBA Import of web page data broken up by "pages" hyperlinks

  1. #1
    Registered User
    Join Date
    11-13-2011
    Location
    montreal,canada
    MS-Off Ver
    Excel 2010
    Posts
    4

    VBA Import of web page data broken up by "pages" hyperlinks

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1