+ Reply to Thread
Results 1 to 4 of 4

How to get table data from a website having number of pages

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    Shimla, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to get table data from a website having number of pages

    I want to scrap data from a web page to excel sheet(s), the web page has more than 100+ pages and each page has 20 rows.
    the url is like this:

    http://abc.com/victory/Display?step=...ue=a&circle=0&pg=1&order=name_style (not the actual url)

    when we jump to next page only this changes pg=1 like 2,3,4.....so on

  2. #2
    Registered User
    Join Date
    09-17-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: How to get table data from a website having number of pages

    How anyone can help you without checking the website.

  3. #3
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: How to get table data from a website having number of pages

    I think it's self-evident. Create a loop and change page number accordingly in the URL in order to download all pages.
    If you are pleased with a member's answer then use the Star icon to rate it.

  4. #4
    Registered User
    Join Date
    10-12-2013
    Location
    Shimla, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to get table data from a website having number of pages

    Thanks Dear,

    Problem already solved
    Last edited by dknetbiz; 09-17-2014 at 11:26 AM.

+ 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. Need to develop a macro to copy the data from multiple pages on same website
    By loveexcel2014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2014, 05:33 PM
  2. Import data from multiple pages on a website to one file
    By a1b2c3d4e5f6g7 in forum Excel General
    Replies: 0
    Last Post: 06-19-2014, 04:44 PM
  3. Pull data from multiple pages on same website
    By willhutton93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2014, 03:15 PM
  4. Macro/VBA code for COLLECT DATA FROM VARIOUS PAGES OF ONE WEBSITE..
    By gunjan.nasit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2013, 03:26 PM
  5. Collect data from various pages of one website to excel and format it in table
    By gunjan.nasit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2013, 07:06 AM

Tags for this Thread

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