Batch convert a folder of DOCX files to PDF
Posted 20th April 2016
11 comments
Use this handy PowerShell script to convert all Microsoft Word DOCX files in a directory into Adobe Acrobat PDF files.
RGB to HEX in Excel
Posted 24th March 2016
11 comments
Use Microsoft Excel to convert Red-Green-Blue (RGB) values into hexadecimal colour codes and display the relevant colour graphically beside each output.
Rearrange Excel columns via Visual Basic
Posted 16th March 2016
17 comments
A simple VBA script for rearranging the order of columns in an Excel spreadsheet.
Convert CSV to XLSX via PowerShell
Posted 9th March 2016
38 comments
A nifty PowerShell script that will take a delimited CSV file and convert it to a XLSX file.
VBA: Create a list of all external data references in Excel
Posted 15th September 2015
3 comments
Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.
Applying dates to normalised data in Excel
Posted 19th July 2015
No comments
Use this formula to apply dates to all variables in a normalised linear list data set in Excel.
Format mail-merge date fields in Microsoft Word
Posted 16th July 2015
6 comments
Microsoft Word will format dates as mm/dd/yyyy as the default in mail merge documents. The field codes can be changed to enable dates in any format.
Easily generate Code 128 barcodes in Excel
Posted 29th May 2015
65 comments
This simple methodology can be employed to reliably generate Code 128 barcodes in Excel.
Combining R1C1 and A1-style cell referencing in Excel
Posted 11th May 2015
3 comments
Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.
INDEX MATCH instead of VLOOKUP
Posted 22nd January 2015
1 comment
INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.