Macro for multiple webpages query

[pathfinderwm]

(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.

[natefarm]

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.

[pathfinderwm]

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.

[natefarm]

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

[pathfinderwm]

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.