G26th 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.
G25th 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.
G15th September 2015
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.