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

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: , , |1 Comment

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

Send Multiple Emails Tool – Ver 4.0 [Imp Bug fixes]

Dear friends, The version of Send Multiple Emails Tool, I released last, there was a small issue with the mail sent by outlook. Thanks to you all for providing me the prompt feedback about the same. I have fixed it but I have not changed the version of the tool as such. It will still remain as version 4.0. This [...]

FREE Download : Send Multiple Emails Tool – Ver 4.0

Dear LEM Readers, Here I come with a new version of Send multiple Email using Excel. Are you planning to send all of your friends a Happy New Year Email for this coming new year 2017? Sounds good !! but would you put every one's email in to List and send them all a generic message?? Noooo!! how about sending [...]