Previously in the article below I’ve explained how you can get data from the web using query tables in VBA: Excel VBA, Retrieving Data From a Website Using a Query Table The problem with using Query Tables, is that they are slow. A faster method
In this article I will explain how to retrieve data from a website using a query table and VBA. Previously in the article Excel Getting Data From the Web I’ve explained how you can use Query Tables to import data from the web into an excel worksheet.
In this article I will explain how you can get data from the web using a Data Query in Excel. I will be providing an example on how to get the CAD to USD currency exchange rate from the website http://finance.yahoo.com/q?s=usdCAd=x. Note: The owners of the website http://finance.yahoo.com/q?s=usdCAd=x may
In this article explain how you can write an excel application to retrieve currency exchange (forex) rates from the website http://finance.yahoo.com/. This application also allows users to select only the currency exchange (forex) rates he/she needs. You can download the codes and files related to this article