Scripts, systems & field notes.

Windows OS 20 Oct 2025 26861

Apple Magic Trackpad with Windows 11 Intel

A quick article to get an Apple Trackpad working with an MS Windows 11 Pro (Intel 64) workstation.

Read note →

Windows OS 03 Jun 2021 36735

Windows OS: Alt Codes / Symbols / Special Characters

This is a simple article to demonstrate how to type special characters not found on your keyboard or on a Qwerty UK/US keyboard layout.

Read note →

Windows OS 30 Jul 2020 51466

Windows 10: Shortcut Apps to Settings

This is a list of apps that if run via the run command, or used in a desktop shortcut, or that you want to include in automation software such as AutoHotkey, opens any specific Windows OS settings page. This does not make the change to the setting itself, just displays it to the user for them to make the choice.

Read note →

Excel 23 Jul 2019 16059

MS Excel - Open CSV with Long Numbers

This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989 1457102000000135566,Stanley,01709123456,14571020000...

Read note →

Excel 14 Feb 2019 30479

Excel - Check a column for values found in another column

This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively.

Read note →

Excel 11 Feb 2019 39752

MS Excel - Split Workbook into separate files per sheet

This article serves to explain how to split a spreadsheet consisting of multiple sheets into separate files per sheet.

Read note →

Windows OS 04 Oct 2018 25719

Windows Live Mail Error ID: 0x8DE00005

A quick article on how to update the Microsoft Live Server URL for Hotmail using Windows Live Mail. Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new account will have all your mail. The error Unable to send or receive messages for the Hotmail (someone)...

Read note →

Excel 04 Oct 2018 32258

Import Excel CSV file as JavaScript array

What I have: A CSV file exported from Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ , , ]; What I want again: Read a CSV file already uploaded with JavaS...

Read note →

Windows OS 23 Sep 2015 20419

VBScript to retrieve Windows Product Key

A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional.

Read note →