1. P

    Extract Data from Web Query

    Hi Guys, So I have run a web Query using a .iqy text file which is pulling data from a popular cryptocurrency site called CoinMarketCap. I am using api links for individual coins in order to get there price is USD updated every minute to try and track in an excel ticker. An example of a url...
  2. D

    Power Query to iqy

    Does anyone know how to connect to an iqy through Power Query? Currently I'm using Power Query to connect to separate Excel file that contains the iqy. I would really like to skip the "middleman" and use Power Query to direct connect to my iqy. Thanks in advance.
  3. M

    VBA Releasing IQY file connections

    I have a report I am working on that requires data from multiple IQY files generated from the same web platform. My problem is that when I run it, excel seems to be holding the first iqy file URL and repeating the other data calls with that same IQY file. The URLs are the same, but there is an...
  4. J

    How do I get WSDL-request responses into Excel... WITHOUT VBA?

    I need to be able to submit an XML request to a WSDL, get the XML response and deal with it. The manual way is that I go into SOAP-UI, load up a request, supply parameters, click the green triangle, get the response, and save it as an XML file. Then in Excel I import it using Data / From Other...
  5. M

    .iqy syntax

    I am having a general problem in getting data into Excel from the web. There is something wrong either with my syntax or my understanding of the HTML Page Source (quite possible since I have but a cursory knowledge of HTML). For example, here is a sample iqy file: WEB 1...
  6. J

    Automating Importing IQY Files

    I am writing VBA macro in Excel 2003 that includes opening an IQY file. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> When I open an IQY file manually, I get a Import Data dialog box that asks<o:p></o:p> <o:p></o:p> "Where do you want to put...
  7. S

    Creating dynamic link to web page in Excel

    I am using Excel 2007 on Windows 7 Pro I have a spreadsheet which is updated from a website. Presently this works from a permanent URL. I am looking to create a dynamic URL whereby Excel will have two cell which represent the start date and end date, which are to form part of the websire URL...
  8. B

    Refresh Web Data with required Login

    Hey all! I have been looking at methods to refresh data from a website where you need to login and I have seen a few ways of doing this. I know it does vary from site to site and of course my preferred method, but at this point I am looking for advice on the best possible solution to my issue...

Some videos you may like

This Week's Hot Topics