Posted 26th November 2015
A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.
Posted 25th November 2015
A convenient PowerShell script that will detect all of the CSV files in a directory and merge them into a single XLSX file. Each CSV becomes a worksheet in the XLSX.
Posted 15th September 2015
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.