Skip to content

Use a batch file to run your PowerShell scripts

G1st August 2016 

CNo comments

This simple batch file will enable a PowerShell script file (*.ps1) to execute with Administrator permissions in Windows.

Read the full story

Folder or file browser dialogues in PowerShell

G28th July 2016 

C1 comment

Make life easy for the users of your scripts: Rather then entering file/folder paths at the command line, let them select from a GUI dialogue box.

Read the full story

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

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

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

G24th May 2016 

CNo comments

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

Read the full story

Batch convert a folder of DOCX files to PDF

G20th April 2016 

C1 comment

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 

C3 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 

CNo comments

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

Read the full story