+ Reply to Thread
Results 1 to 6 of 6

Problems getting external data from the web

  1. #1
    Forum Contributor
    Join Date
    12-20-2014
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    137

    Problems getting external data from the web

    I'm trying to import data from the site below by setting up a new web query, but the import button is always greyed out. I've tried changing all the web query options but no luck. Can anyone suggest how I can get data into excel from this site?

    thanks

    http://www.tradingeconomics.com/country-list/rating




    I have also posted this question at:
    http://www.ozgrid.com/forum/showthre...436#post758436
    Last edited by John19; 10-16-2015 at 07:05 PM.

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Problems getting external data from the web

    Using Excel 2010, the only way that I could get the data was to manually select, copy and paste into Excel. Web query failed miserably. The copy in Excel required no processing to be usable. Even the hyperlinks work in the Excel copy.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Contributor
    Join Date
    12-20-2014
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    137

    Re: Problems getting external data from the web

    i need a direct connection which refreshes regularly because the date changes constantly on the site, copy paste would be too tedious

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Problems getting external data from the web

    If it is possible, it is only possible with VBA. The website doesn't recognize importable tables. I did notice that they have some kind of streaming software/service available.

  5. #5
    Forum Contributor
    Join Date
    12-20-2014
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    137

    Re: Problems getting external data from the web

    i've just tried setting up the web query for the same site on another computer and it work? don't understand why it worked on the second computer because its same excel 2010 but its done.

    thank you anyway

  6. #6
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Problems getting external data from the web

    That site is strange. I got a partial download on one try but couldn't repeat it.

+ 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. [SOLVED] Problems getting data from external workbook
    By ukhellfire in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2013, 04:44 AM
  2. External Linkage Problems & Error Message
    By nofzinger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2009, 10:25 AM
  3. External reference problems
    By theheavi in forum Excel General
    Replies: 2
    Last Post: 04-11-2008, 06:11 AM
  4. [SOLVED] Problems updating external data ranges
    By Matt S in forum Excel General
    Replies: 0
    Last Post: 08-09-2006, 07:44 AM
  5. External database causing problems?
    By Michael Malinsky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 02:40 PM
  6. Repost:Problems with external references
    By 50pingviner in forum Excel General
    Replies: 1
    Last Post: 12-06-2005, 12:10 PM
  7. Importing External Data (Access) problems
    By jwrnana in forum Excel General
    Replies: 0
    Last Post: 09-01-2005, 05:05 PM
  8. [SOLVED] Import external data problems
    By JR in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 05:05 AM

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