Monthly Archives: October 2017

VBA to Open or Create a Password Protected Workbook

Dear Friends, Previously I have written about how to protect and un-protect a Sheet in a Workbook. In this article, I am going to cover all about protecting and unprotecting a workbook. This is going to be a short and simple article, yet informative and useful for your day to day VBA programming. In this article, I am going to [...]

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 [...]