Did you know you can set up a sound alarm in Microsoft Excel? This is a great trick if you need a reminder or alert while working with your data—whether it’s for a specific time, a deadline, or even when certain values are met in your spreadsheet. In this blog post, I’ll guide you through how to set… Read More »
It’s always good to perform an inventory of workstations you might be responsible for. This doesn’t mean just writing down make, model and serial number. You need a list of software installed on those machines as well. Using VBScript, you can easily get a list of the installed software on a local or remote workstation, along with other… Read More »
This is a pretty basic function which allows you to convert an IP address, which a string, into a long integer. But where would this be useful? A Basic Example Let’s say you have a website, and you want to disallow certain IP address ranges from accessing the site. Let pretend that you want to stop the range… Read More »
I recently had a need write records from a database to text files, with one file per record. This post covers how I did it, with VBScript. This project was actually part of a much larger project, which in reality was one of those “Let’s see if I can do it” type of projects. It turned out successful,… Read More »
This handy little script will dump out your Active Directory users to an Excel spreadsheet. Simply run it with an account that has the necessary permissions to query AD, and it will do the rest, including notify you with a dialog box when it is done.
This handy little VBscript to create a system restore point can be encapsulated in a function and can save you from yourself.
From time to time, it might be required that large number of generic user account objects be created in an Active Directory domain. Here is how to do it, quickly.
When deploying large numbers of computers, there are several methods of joining a machine to a domain. Since I am a big fan of VBScript (shhh!), I use this method to join the machine.
I have been asked for this little snippet of code by several users, so here it is. It does something that sounds really simple, but “classic” development languages from Microsoft don’t seem to have a built in function for it. Let’s say that you are righting some sort of application that requires certain fields to contain numbers only.… Read More »
Ever wanted to grab all the digits out of a string? This handy little function will do it. Not sure what purpose this would server, but someone requested it, so here it is.