+ Reply to Thread
Results 1 to 2 of 2

Solutions for fetching table data from website

Hybrid View

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    1

    Solutions for fetching table data from website

    I am trying to fetch some data from flightstats.com and have that information imported into an excel worksheet.

    Here is the link to the data:
    http://www.flightstats.com/go/Stats/...&x=4&y=5#arr7H

    I am looking for a way to possibly run a macro to link to this website and this particular query "Airport Scorecard" for the Cincinnati Airport (or any airport for that matter) daily to retrieve the information.

    I tried going under the "Data" tab and importing the data under the "From Web" icon and was unable to have any success.

    Any advice or suggestions are much appreciated.

    Thank you.

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

    Re: Solutions for fetching table data from website


    • Easy way : VBA QueryTable …

    Automate Internet Explorer

    MSXML Object Library Routines

    Many samples on this forum and all over the Web …

    _________________________________________
    Je suis Charlie

+ 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 help: any solutions for searching data in Google to see if linked to a website?
    By halestorm29 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2014, 11:32 AM
  2. Fetching Data from website
    By catchanil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2014, 09:45 AM
  3. data fetching from website
    By nitin.s@itm.edu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2013, 01:25 PM
  4. fetching data from search results from a website using cell contents?
    By Cutters in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2012, 07:29 AM
  5. fetching data from a table
    By MickeyP in forum Excel General
    Replies: 3
    Last Post: 06-17-2009, 12:13 PM

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