title: Microsoft Excel 2010 Web Query Macro: Pulling Multiple Pages From One
body: <p>I am looking to find some help on this Macro.. The idea is, upon execution the Macro will pull The Data from a Web Page (I.E <a href="http://www.link.com/id=7759" rel="nofollow">http://www.link.com/id=7759</a>) and place it into let's say Sheet2, and then Open up Page 2, and place it right below Page 1's Data in Sheet 2.... And So on and So on until a set Page Number.. Ideally I would like it just to pull The following in order;</p>
  
  <p>Title
  Artist
  Type
  Paper Size
  Image Size
  Retail Prize
  Quantity</p>
  
  <p>And further more it is ideal that is placed in proper columns and rows of 4 and 8 Rows down(Columns Across just like in the web page).</p>
  
  <p>Any help on this would be greatly, greatly appreciated. I have done some research and found similar macros, sadly have had no luck getting them to work for me. Mainly VB's fail to go through as well.</p>
  
  <p>Bit of useful info (maybe) I figured this out when I was trying to write my own, maybe it will save who ever helps some time..</p>
  
  <pre><code>.WebTables = "8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38"
  </code></pre>
  
  <p>Those are the tables for each item I want to put into the Que...</p>