+ Reply to Thread
Results 1 to 5 of 5

Macro for multiple webpages query

  1. #1
    Registered User
    Join Date
    04-28-2011
    Location
    Illinois
    MS-Off Ver
    Excel 2010
    Posts
    3

    Macro for multiple webpages query

    (First time poster!) I am trying to pull data from a website that will only show 15 results. There are a total of 631 results, which means there are around 42 pages. I have been searching for an answer on this, but cannot find the solution. If I run my current macro, it will only repeat the first page's results 42 times.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Macro for multiple webpages query

    I haven't done web interaction programming so I'm not familiar with the code, but could it have to do with "PageNumber=1" being hard-coded?
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-28-2011
    Location
    Illinois
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Macro for multiple webpages query

    That line is just in the .Name line, so it shouldn't have any impact on it. Should it? I could be wrong since I am quite new at this. If you notice on the URL line

    Please Login or Register  to view this content.
    I replaced the hard coded "PageNumber=1" to PageNumber=" & i & " hoping that would help change the pages dynamically.

  4. #4
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Macro for multiple webpages query

    Yes, I saw that, but don't know if this other one needs to be a variable also.

  5. #5
    Registered User
    Join Date
    04-28-2011
    Location
    Illinois
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Macro for multiple webpages query

    Nate, thanks for the response. I did change both, but it is still just repeating the first page of the search 42 times. I actually just test it to 3 pages, so it doesn't chug all that data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting data from multiple webpages into excel
    By missbg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2013, 12:40 PM
  2. Scraping Data from tables in multiple webpages
    By heiyan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 10:35 AM
  3. [SOLVED] Web query for multiple webpages - shift down
    By tnewell2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2012, 11:44 AM
  4. Web query for multiple webpages - shift down
    By Yossarian1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2011, 04:29 PM
  5. Macro to grab webpages
    By Sir Codesanot in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2007, 09:03 PM

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