Skip to content
lemnatec_logo

Migrate a local LemnaTec database

G8th June 2016 

CNo comments

A step-by-step guide for migrating a local LemnaTec database between network drives.

Read the full story

robocopy-robot

Robocopy

G24th May 2016 

CNo comments

Use the built-in Microsoft “robocopy” utility to move or copy files en masse.

Read the full story

docx-to-pdf

Batch convert a folder of DOCX files to PDF

G20th April 2016 

CNo 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

excel-logo-2013

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

colour-wheel

RGB to HEX in Excel

G24th March 2016 

CNo 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

excel-2013

Rearrange Excel columns via Visual Basic

G16th March 2016 

CNo comments

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

Read the full story

excel-logo-2013

Convert CSV to XLSX via PowerShell

G9th March 2016 

CNo comments

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

Read the full story

15-formats

Rotate or flip multiple image files using PowerShell

G4th March 2016 

CNo comments

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

Read the full story

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