+ Reply to Thread
Results 1 to 3 of 3

fetch website data into excel using vba excel macro

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    chicago IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    fetch website data into excel using vba excel macro

    I am trying to code a VBA macro that downloads the table that appears in the following link:

    http://www.flightstats.com/go/Flight...ype=0&x=50&y=6

    I fount the following code available at another forum which does something remarkably similar to what I am trying to achieve, but I can't make it work with the website I am trying this on:

    (I found the code I'm tweaking at
    http://stackoverflow.com/questions/1...ba-excel-macro)

    Please Login or Register  to view this content.
    I basically just modified the hyperlink and the element ID:

    Please Login or Register  to view this content.
    But this really does not do anything for me. Any thoughts on how I need to tweak this to make it work?

    Thank you for your help!!!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: fetch website data into excel using vba excel macro

    The table you want doesn't have an id but could be identified using it's class which is 'tableListingTable'.

    Here's some rough code that seems to work, that nested With, For and If part can probably be tidied up a bit
    Please Login or Register  to view this content.
    Last edited by Norie; 08-08-2013 at 11:11 AM.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-07-2013
    Location
    chicago IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: fetch website data into excel using vba excel macro

    Thank you SO much Norie, that works beautifully!

+ 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. Excel Macro to copy paste ecel data to website
    By muthu_1289 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 11:32 AM
  2. Macro to extract table data from website into my excel file
    By garbisrobert in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2012, 02:38 PM
  3. Macro that put to exel, data that coming from excel website
    By angelo0921 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2010, 05:00 PM
  4. Need Excel VBA macro to fetch data from notepad
    By yourskarthik in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2010, 02:00 AM
  5. fetch data from excel page
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2006, 11:15 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