Posted 14th October 2022
If your organisation utilises Microsoft Azure or Purview to apply “security labels” to your Office documents, you may be compelled to have unsightly headers and footers in your documents. There is a way around this, but it’s clunky.
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.