G8th February 2016
Use Microsoft PowerShell to add or remove the ‘read only’ attribute from large batches of files in a directory.
G3rd December 2015
If a required font is missing, this script will alert a user that the font needs to be installed on their local computer before a Microsoft Word file will display properly.
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.
G14th October 2015
Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.