Color Palette in Excel VBA

Many a times you will need to show colors at run time for your cool Excel application. A good mix of Colors can make a application more att...

Get List of Files and Sub-Folders in a Folder

While working with VBA, one of the many common things to do will be, getting a list of files and sub-folder in a folder . The following cod...

Currency Exchange Rate Reporter

Do you regularly keep check on the currency rates? If the answer is yes, the below will prove more than useful to you. The below is a smal...

Create Directory Tree

When you are dealing with too many files at a time, sometimes you feel the need to list them. One way of doing so and managing that is put...

Date Randomiser

If you are into Article spinning you may feel the need of a random date creator to generate some random dates. These dates can then be use...

Browse a Folder in VBA

In many applications or tools you will build with Excel VBA, you will often come across a need to browse a folder. One way of getting the ...

Get Special Folders Path in VBA

While writing small or big applciations in Excel, you might come across a need to get the path of Special folders in windows. As these pat...

Read/Parse a Text file line by line using VBA

There are a couple of inbuilt features in Excel to import data from text files  Import Text Data (Delimited) to Excel Import Text Data ...

Excel Macros - Hello World

Macros is one of many things which makes an application great. MS Excel also contains this feature. If you have a repetitive task on Excel...