How to Link Cells to Files/Folders using Excel VBA?
There are many cases where we want to have a Hyperlink on a cell that opens a document / image etc. In the following snippet we can see how that… Read more »
Monthly Archives: August 2016
VBA Code to Interact with MS Word
Recently, I had the task of writing a program to populate an SLA (Service Level Agreement) Report. The SLA Report was a Word document with many tables of data and… Read more »
Calculate the number of working days between two dates
As an Excel or data analyst, dates in datasets are common and usually involve some work to take from raw data stage into meaningful reports. Employee datasets, sales datasets and… Read more »
How to copy set of files from one folder to another using VBA?
Here is a simple code that moves all the files from one folder to another using XCOPY. You can use all the options of XCOPY with VBA Sub Copy_Bunch_Of_Files() Shell… Read more »
How to convert a date into a month name?
Converting a date into a month name is an extremely easy thing to do in Excel, but like everything it is only easy if you know how There are a… Read more »
Trick to Complex Excel Formulas
There comes a time in many Excel users’ careers where we start to write incredibly complex Excel formulas to summarize or extract data from poorly structured workbooks. I’m not talking… Read more »