Skip to content
power-shell

Automatically delete files listed in a CSV

G26th September 2014 

CNo comments

A PowerShell script that reads a list of files in a CSV and deletes them from a computer drive automatically.

Read the full story

google-chrome

Fix the ‘Gill Sans’ font bug in Chrome

G25th September 2014 

C2 comments

Bug fix: A quick CSS remedy to ensure that Google Chrome 37 displays the Gill Sans font correctly.

Read the full story

power-shell

Script to list image files by size and resolution, export to Excel

G24th September 2014 

CNo comments

Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.

Read the full story

excel-logo-2013

Open and close Excel workbooks in the background

G4th September 2014 

CNo comments

Use a Visual Basic for Applications (VBA) script to open secondary Excel workbooks as data sources when opening a VLOOKUP-dependent workbook.

Read the full story

excel-logo-2013

Round to the nearest work day in Excel

G31st July 2014 

CNo comments

Use this basic formula to round any scheduled date to the next working day (Monday to Friday) for use in workplace task planning.

Read the full story

excel-logo-2013

Automatically update Pivot Tables in Excel

G15th July 2014 

CNo comments

A simple VBA script that refreshes (updates) all Pivot Tables within an Excel workbook after any change to a worksheet.

Read the full story

excel-logo-2013

Add a suffix to selected cells in Excel

G12th July 2014 

CNo comments

Use this handly VBA macro to automatically add characters to the end of values in a selected range of cells.

Read the full story

silverstripe-logo

Upgrading Silverstripe 3.1.x

G5th July 2014 

C1 comment

Instructions for upgrading an installation of SilverStripe 3.1.x to the latest version.

Read the full story

power-shell

Script to list files by type and size, export to Excel

G1st July 2014 

CNo comments

Instructions for using a Windows PowerShell script to compile computer file data and export the results to Excel as a tab-delimited CSV.

Read the full story

Zuckerberg-F8-Facebook

Combining Open Graph meta tags with valid HTML5

G27th June 2014 

C2 comments

Maintain a valid HTML5 website whilst using Facebook’s Open Graph meta tags on your static page or WordPress blog.

Read the full story