Have you ever wanted to import contact details from VCF data in to an Excel sheet? Follow this article and create your own VCF reader that would import data from your VCF files into Excel worksheets Download Now If you want to start to use the...
Read more »How often do we get dates in spreadsheets supplied to us as 12.26.2016, or 26/12/2016 (UK format), only to be told the date is invalid or there's no month 26? This article explores fixing dates with VBA, using TRIM, LEFT, RIGHT and MID functions....
Read more »This exercise shows how to read data from a website, in this case up-to-the-minute currency exchange rates from Yahoo.com. It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel...
Read more »