Blog

Read Welcome Message..

Are you visiting LearnExcelMacro.com first time?

Welcome to the learnexcelmacro.com. Do not forget to read .. welcome message written for you...
Read Welcome Message..

Schedule to close Workbook using Application.OnTime

Dear Friends, In this article I am going to teach you about Application.OnTime. I will also explain you the usage of this method with two examples: How to schedule a workbook to close at specified time How to Schedule a workbook to close if left idle for specified duration This method is used to execute a procedure in Excel VBA [...]

What is Immediate Window and how to use it in Excel VBA

Dear Friends, Have you heard of Immediate Window in Excel VBA programming? Do you know how to make use of it? If you have not been using this while doing vba programming then trust me you were missing something really cool stuff which excel provided to the programmers. In this article I am going to explain you the following 1. [...]

Hide Group outline symbol in Excel – [Manual Option + VBA]

Dear Friends, In this article, I am going to share a quick tip related to Excel. It was asked by one of my colleague recently. How to show or hide Group Outline Symbol in Excel Workbook when you group any row or column. Here I will show you both the methods - 1. How to hide Group Outline - Using [...]

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

By |Categories: Excel Macro, Excel Macro Basics|Tags: , |0 Comments

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

By |Categories: Excel Tools, User Defined Function|Tags: , |0 Comments

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

By |Categories: Excel Macro, Excel Tools|Tags: , , |2 Comments

Top 4 VBA Methods to Export Excel data as CSV File

In this article, I am going to teach you 4 VBA Methods of - how to export data from Excel Range to a CSV file format using Excel VBA.

VBA Guide to Interact with Text Files – Part – 2 of 2

Dear Friends, I am back with the second part of the tutorial- VBA Guide to Interact with Text Files – Part – 1 of 2. This is the final part of this tutorial. In previous article, mainly we learn about How to Open a Text File and How to write to Text File using VBA code. There were some [...]

VBA Guide to Interact with Text Files – Part – 1 of 2

Text files are one of the simplest, lightest file types. This is the reason it is highly used in programming to store lot of configuration related data, logs and so many other necessary data which is used by programs more frequently. If you browse your Program files folder in windows almost every program will have some text files for storing [...]

Validate BurgerServiceNummer (BSN) using Excel VBA

Important Note: This post will make more sense to those who stays in Netherlands. But wait.. even if you do not stay in Netherlands, you will learn some interesting Algorithm!! BSN is short form of Dutch Word - BurgerServiceNummer . In English, this is called  Citizen Service Number. This is a unique Personal Identification Number assigned by Netherlands [...]