Thread: Web query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mahesh Mahesh is offline
external usenet poster
 
Posts: 29
Default Web query

Hi,

I have created a web query that pulls the required data from the web site
from the page 1. But there are 100 pages and i need to collect the data from
all the 100 pages.following is the url for the same. If you see in the url
N=0 is the first page and N=12 will be the second page and multiples of 12.
How can i increment this and automate. Please advice.
URL;http://www.lowes.com/lowes/lkn?action=productList&N=0&Ntk=i_appliances&Ntt=GE ", _