Skip to content
power-shell

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

G8th February 2016 

CNo comments

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

Read the full story

owncloud_logo_square

Sync phone contacts via OwnCloud

G7th January 2016 

CNo comments

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

15-formats

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

icon_microsoft_word_2013

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

excel-logo-2013

VBA: Convert text to columns for all worksheets in Excel

G26th November 2015 

CNo comments

A small Visual Basic for Applications (VBA) script which will loop through all sheets in an Excel workbook and convert text to columns.

Read the full story

power-shell

Combine multiple CSVs into one XLSX via PowerShell

G25th November 2015 

CNo comments

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.

Read the full story

power-shell

Batch rename files using PowerShell and a CSV

G23rd November 2015 

CNo comments

Use this simple PowerShell script to change hundreds or thousands of file names automatically, based on a CSV.

Read the full story

owncloud_logo_square

OwnCloud: Create your own private cloud service

G3rd November 2015 

CNo comments

There is a good alternative to DropBox, OneDrive or Google Documents to synchronise your digital life and that is to run your own cloud. Here’s my experience in setting-up an OwnCloud installation.

Read the full story

apache-logo-square

Redirect HTTP to HTTPS

G28th October 2015 

CNo comments

Use .htaccess to redirect all server traffic from HTTP to HTTPS

Read the full story

icon_microsoft_word_2013

VBA: Automatically format specific text in Microsoft Word

G14th October 2015 

CNo comments

Use this simple Visual Basic for Applications (VBA) script to reformat any text string within Microsoft Word.

Read the full story