Auto Acronyms

By Mark Harris

Parses a Word document and produces a list of the all the acronyms in the text. It also tries to include the acronym defintion from 4000 listed acronyms.

USB Stick Log

By Mark Harris

Log the people who use your shared memory stick. With an autorun file that loads an excel spreadsheet when the USB stick is pluged in. The VBA then adds the users login details, time and the size of the files on the memory stick to the next blank row in the spreadsheet. The user is prompted to let them know their…

File Name Formatter

By Mark Harris

VBA within Word that formats all files within the current folder / subfolders matching a regular expression search to a file name specified. e.g. [2007-01-01]* becomes 2007-01-01* e.g. (2007-01-01)* becomes 2007-01-01* e.g. [20070101]* becomes 2007-01-01* e.g. (20070101)* becomes 2007-01-01* e.g. 20070101* becomes 2007-01-01* e.g. *20070101.??? becomes 2007-01-01 *.??? e.g. *(20070101).??? becomes 2007-01-01 *.??? e.g. 2007-01-01*…

Auto Index

By Mark Harris

Generates an index listing all the files within a folder and its subfolders. Includes hyperlink to the document and counts the number of pages (Word only). Useful if you documentation processes demand an index sheet at the front of a paper file.