+ Reply to Thread
Results 1 to 4 of 4

External web data query fails to insert table data

  1. #1
    Registered User
    Join Date
    10-11-2011
    Location
    Pittsboro, NC
    MS-Off Ver
    Excel 2013
    Posts
    11

    External web data query fails to insert table data

    An external data web query points to a web site that offers a foreign exchange rate calculator.
    In my browser, I selected the specific currency pair I need and used the resulting url in the web query.
    The "New Web Query" pane resolves the url correctly and allows me to select the table data I want (the little yellow arrow turns to a green check mark).
    However, when I hit "Import" and select the target cell, the only data returned is the parameters from the url and an error msg (This web query returned no data...).
    How do I get the query to pass the parameters to the website correctly?

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: External web data query fails to insert table data

    These can be tricky as some sites dont allow you to pass parameters, and some you have to click a button to submit.
    i would not a url to be able to do more.
    Other alternative is to use vba to do a data scrape.
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  3. #3
    Registered User
    Join Date
    10-11-2011
    Location
    Pittsboro, NC
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: External web data query fails to insert table data

    I remember reading somewhere that it was possible to use some kind of text file - presumably in conjunction with the web query - to pass parameters. Any clues how that might work?

  4. #4
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: External web data query fails to insert table data

    not sure about that one, but if you upload a work book with what you want and the url I can take a look

+ 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. insert entire row for new data, external data range doesnt work
    By orlya1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2006, 03:45 PM
  2. [SOLVED] Excel Query fails to include data?
    By Office 2K Issues in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2005, 09:15 PM
  3. 1-variable Data Table w/ dependency on MS Query fails to update correctly
    By trippknightly@hotmail.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2005, 11:06 PM
  4. [SOLVED] 1-variable Data Table dependent on MS Query fails to update correctly
    By trippknightly@hotmail.com in forum Excel General
    Replies: 0
    Last Post: 03-30-2005, 03:06 PM
  5. [SOLVED] Excel>Data>Import External Data>New Web query
    By Bruce Officer in forum Excel General
    Replies: 0
    Last Post: 03-13-2005, 06:06 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