Microsoft Excel and Powerpoint are perfect partners for Dynamic Tables and Dashboards. PowerPoint 2010 and PowerPoint 2013 introduced improvements to a lot of features, but sadly PowerPoint Tables was not… Read more »
PDF is always the universal format for sending the files. With lot of versions of MS Office and other Office suites around, it is always better to circulate the Deck… Read more »
PIVOT tables are a great way to summarize data but sometimes it is important to be able to split a PIVOT table out, generating multiple reports based off all the… Read more »
Today I am going to discuss simple ways to write the VB programming in the most efficient manner to, optimize the VBA code saving a lot of time for the… Read more »
So you’ve found some VBA code on the internet that will save you hours and hours of work, but how do you get it into Excel and use it? Often… 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 »
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 »
Protecting your VBA scripts may seem a little extreme, especially with so many IT experts now recognising the value of open source and free access but it does have a… Read more »
Here is why I think VBA is so great, but first let’s try and define VBA. A tightly integrated application automation system that allows professionals from non software development disciplines… Read more »