Skip to content

Batch convert a folder of DOCX files to PDF

G20th April 2016 

C7 comments

Use this handy PowerShell script to convert all Microsoft Word DOCX files in a directory into Adobe Acrobat PDF files.

Read the full story

RGB to HEX in Excel

G24th March 2016 

C7 comments

Use Microsoft Excel to convert Red-Green-Blue (RGB) values into hexadecimal colour codes and display the relevant colour graphically beside each output.

Read the full story

Rearrange Excel columns via Visual Basic

G16th March 2016 

C12 comments

A simple VBA script for rearranging the order of columns in an Excel spreadsheet.

Read the full story

Convert CSV to XLSX via PowerShell

G9th March 2016 

C23 comments

A nifty PowerShell script that will take a delimited CSV file and convert it to a XLSX file.

Read the full story

VBA: Create a list of all external data references in Excel

G15th September 2015 

C3 comments

Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.

Read the full story

Applying dates to normalised data in Excel

G19th July 2015 

CNo comments

Use this formula to apply dates to all variables in a normalised linear list data set in Excel.

Read the full story

Format mail-merge date fields in Microsoft Word

G16th July 2015 

C5 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.

Read the full story

Easily generate Code 128 barcodes in Excel

G29th May 2015 

C36 comments

This simple methodology can be employed to reliably generate Code 128 barcodes in Excel.

Read the full story

Combining R1C1 and A1-style cell referencing in Excel

G11th May 2015 

C2 comments

Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.

Read the full story

INDEX MATCH instead of VLOOKUP

G22nd January 2015 

C1 comment

INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.

Read the full story