Skip to content
power-shell

DOS 8.3 short paths via PowerShell

G5th July 2016 

CNo comments

Use this PowerShell script to discover the DOS 8.3 path name for any selected folder in Windows.

Read the full story

power-shell

Merge multiple CSVs with PowerShell

G28th June 2016 

CNo comments

Use this simple PowerShell script to merge multiple CSV/TSV/TXT files into one.

Read the full story

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 

C1 comment

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