Unix and Linux have had the incredibly powerful grep tool for decades but windows has always been lacking. PowerShell brings the functionality of grep with the Select-String cmdlet. Use Select-String …
Quickly access System Properties in Windows 10 or Server 2016
Access to the System Properties dialog in Windows 10 and Server 2016 frustrates me when it used to be so easy to access. There are lots of routes to this familiar and useful screen, but I find this …
Continue Reading about Quickly access System Properties in Windows 10 or Server 2016 →
String.Format in VBScript or VBA
Because I often switch from writing C# back to VBScript or VBA. The lack of a string.format() method in both languages gets is annoying. So I wrote a small function which performs string substitutions …
Scan to Email with Office 365 using a Multi-function Printer
Setting up a Multi-function device to scan to email via Office 365 is easy. This Microsoft document lists the three possible methods, which are: SMTP Client Submission Direct Send Using an …
Continue Reading about Scan to Email with Office 365 using a Multi-function Printer →
Convert US Dates to UK Format in Excel
If you have a column of dates in Excel that are in US format, it is easy to convert them to UK format. Simply follow these steps: Select the column containing the US Dates: From the Data Ribbon, …
Continue Reading about Convert US Dates to UK Format in Excel →
How to create a Network Connections Shortcut in Windows 10
Press Windows Key + X Press "W" or left click on "Network Connections" Click on "Change adapter options" Drag the Network Connections Icon in the Address bar to your desktop: Access …
Continue Reading about How to create a Network Connections Shortcut in Windows 10 →