Excel Tools

Distance Calculator in Excel VBA [REVISED]

Hi guys, on June 2016, google made some changes around pricing and authentication etc. of its FREE APIs. Distance calculator API was also affected by those changes. I had written an article long back about how to calculate distance and time taken between two places in Excel VBA using google matrix api. In addition to this article, I had also [...]

Random BSN Generator – SoFiNummer Generator

Dear Friends, In one of my previous article, I explained you about Netherlands BSN Number validation. This used to be called as SoFi nummer (Short form of dutch word - Sociaalfiscaal nummer) as well in the Past. Here in this article, I am sharing VBA code and a FREE downloadable excel to generate random BSN numbers. At the end of [...]

VBA to Convert Contact Data in Excel to VCF format

Dear Friends, As you have learnt about interacting with Text files through Excel VBA, it is time to see the usage of those methods you learnt. One usage, you have already seen here, in how to export excel data in CSV format. In this article, I am going to teach you how to Export contacts stored in Excel table as [...]