+ Reply to Thread
Results 1 to 2 of 2

Download and consolidate table data from dynamic URL's VBA

  1. #1
    Registered User
    Join Date
    07-01-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    1

    Download and consolidate table data from dynamic URL's VBA

    1st timer here, great forum.

    I've come so close to figuring this out, but the nature of the URL's I'm visiting is making it tough.

    I have a list of about 400 profile names. The profiles public information is avaible by visiting a page like www.example.com/profile=XXXXX, where XXXXX is the profile name.

    I'd like to automate the process of visiting each of these pages, and importing the table data into excel (table number 136 on each page).

    Bonus: I need to consolidate all of these tables. The original will be something like this:

    Company name: Bob Co
    City: New York
    Website: bobco

    And I need to eventually have the information from all 400 tables consolidated into a more traditional spreadsheet format (with company name, city, website each being their own columns).

    Any help would be excellent. The closest I've come to success is having excel prompt me with a dialogue box with the profile name, and then it automatically creates a new worksheet with the correct table. If I can automate this process so it rips through the whole list of usernames (and consolidates the tables) that would be a huge help.


    Thanks very much.

    Cross-posted: http://www.mrexcel.com/forum/excel-q...ml#post3857083

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Download and consolidate table data from dynamic URL's VBA


    Depends on the real web page code !

    So you must have HTML basics and use inspector tool within your web browser to get what you need …

+ 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. How to consolidate multiple workbooks into one dynamic table
    By Shmemtar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 04:31 PM
  2. Dynamic table formula for sorting data to another table dynamic
    By 650dozer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 07:22 PM
  3. consolidate dynamic data from mulitple spreadsheets
    By pjuli in forum Excel General
    Replies: 0
    Last Post: 05-22-2012, 03:45 PM
  4. Consolidate data into single table
    By JP Romano in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2011, 08:36 AM
  5. [SOLVED] consolidate data, dynamic ranges
    By Excel GuRu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2006, 09:50 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