Code Samples and Documentation

This is a collection of programming samples and the related usage documentation produced over the years by Jason Morris.

Update Logon Scripts

Download Description Documentation explaining how to use Update_Logon_Scripts.xls to update the assigned logon scripts to user accounts on a Domain.   Also explains how to use this tool for basic reporting or record tracking for archival purposes. Update_Logon_Scripts.xls is an Excel based program that assists an administrator with updating the assigned logon scripts to groups of Domain-based user accounts. Even though Microsoft provides command-line based utilities for this purpose, this tool is a little quicker and easier to set up, plus, accounts that did not update will stand out more for reporting purposed. Sample code from Update_Logon_Scripts.xls.

Deploying a 'Weekly Defrag' Scheduled Task

Download Description Documentation explaining how to use the files in Defrag_Task_Files.zip to easily deploy a 'Weekly Defrag' as a Scheduled Task. A ZIP file containing batch files and a 'helper' Excel file to deploy a Scheduled Task called 'Weekly Defrag' on Windows XP-based computers. This is a Excel spreadsheet designed to be used as a 'helper' to modify _Deploy_Defrag_Task.cmd. It allows a list of computer names to be inserted into column A and then creates the commands in column B to be copied into _Deploy_Defrag_Task.cmd Note: Created and tested with Excel 2003. A text file of the scripting contained in the batch file Defrag_Task.cmd. This is the batch script that actually pushes the 'Weekly Defrag' Scheduled Task. A text file of the scripting contained in the batch file _Deploy_Defrag_Task.cmd. This batch script is used as an easy method to call Defrag_Task.cmd to push the Scheduled Task to multiple PCs. A text file of the scripting contained in the batch file _Local_Deploy_Defrag_Task.cmd. This batch script is used as an easy method to call Defrag_Task.cmd to install the Scheduled Task on the PC a PC Technician is currently working on.  This is helpful when building a new PC image to be cloned or on one-off type deployments.

Lotto_Numbers.xls

Download Description Documentation explaining how to use Lotto_Numbers.xls. A Microsoft Excel application for counting number occurances from the results of the Ohio Lottery's Mega Millions game.   Also allows for generating your own random lotto numbers. Note: Created and tested with Excel 2003. Disclaimer: Jason Morris and Lotto_Numbers.xls are not affiliated in any way with the Ohio Lottery or Mega Millions game.   this is provided for entertainment purposes only! Sample code from Lotto_Numbers.xls. This is the code that is used to generate random lotto numbers based on a specified number pool.   Additional code can be viewed by opening Lotto_Numbers.xls and then clicking Tools --> Macro --> Visual Basic Editor.