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