Skip to content

Batch convert a folder of DOCX files to PDF

G20th April 2016 

C11 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

Duplicate Excel cells multiple times

G13th April 2016 

CNo comments

Use this Visual Basic script in Microsoft Excel to duplicate cells a specified number of times.

Read the full story

RGB to HEX in Excel

G24th March 2016 

C11 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 

C15 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 

C37 comments

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

Read the full story

Rotate or flip multiple image files using PowerShell

G4th March 2016 

C3 comments

Use a PowerShell script in Microsoft Windows to rotate or flip large numbers of images automatically.

Read the full story

Powershell: Add or remove the ‘Read Only’ attribute from files

G8th February 2016 

C1 comment

Use Microsoft PowerShell to add or remove the ‘read only’ attribute from large batches of files in a directory.

Read the full story

Sync phone contacts via OwnCloud

G7th January 2016 

C1 comment

Give yourself peace-of-mind by backing-up and syncing your mobile phone contacts’ details to your own private cloud without the need to rely on third-party cloud services.

Read the full story

Batch save images into a new format via PowerShell

G18th December 2015 

CNo comments

Use a PowerShell script to copy all images in a directory and save them into a different image file format.

Read the full story

VBA: Test if a font is installed when a Word file opens

G3rd December 2015 

CNo comments

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.

Read the full story