A place to learn about PowerShell and share stories of automation
October 31, 2007Oct 31, 200710/31/07Hey, Scripting Guy! Given the birthday for one of my Office Outlook contacts, how can I tell how old that person is?— JC
Hey, JC. We have to tell you, JC, that you initially gave us quite a start with this question.
October 30, 2007Oct 30, 200710/30/07Hey, Scripting Guy! I’m trying to create a process that runs a script under the CScript script host. However, I keep running into problems because there are spaces in the script path name. How can I use WMI’s Win32_Process class to run a script under CScript when there are spaces in the script path name?—
October 26, 2007Oct 26, 200710/26/07Hey, Scripting Guy! How can I present users with a dialog box that enables them to rename a file? Ideally I’d like this to be in a loop of some kind, so that they could rename multiple files without having to restart the script.—
October 25, 2007Oct 25, 200710/25/07Hey, Scripting Guy! How can I trigger an alert if an Access database file exceeds a specific size?— MA
Hey, MA. You know just the other day Microsoft.com posted 100 Reasons You’ll Be Speechless, a Web page listing 100 reasons why “Seeing Windows Vista for the first time may leave you searching for words.”
Note.
October 24, 2007Oct 24, 200710/24/07Hey, Scripting Guy! I have a bunch of files that I need to move to new folders; the folder a given file will be moved to is based on the year, a value that appears in the file name. How can I write a script to move these files?—
October 23, 2007Oct 23, 200710/23/07Hey, Scripting Guy! I have a whole bunch of text files in a folder. I need to open each of these files, extract everything between the <filecount> and </filecount> tags, and then write that information to a separate file. How can I do that?—
October 22, 2007Oct 22, 200710/22/07Hey, Scripting Guy! We have a spreadsheet that includes numbers like this: 31738. However, this isn’t supposed to be a number, it’s actually supposed to be a date: 11/22/1986. How can I convert these numbers to dates and then, if needed,
October 19, 2007Oct 19, 200710/19/07Hey, Scripting Guy! How can I retrieve a list of unique users from the Security event log?— KM
Hey, KM. Before we tackle your question we should probably address a question sent in by another reader:
Hey, Scripting Guy! Whatever happened to Monday?
October 18, 2007Oct 18, 200710/18/07Hey, Scripting Guy! How can I tell if a computer is Bluetooth-enabled?— RR
Hey, RR. You know, any time the Scripting Guys get asked something like this, one question immediately pops into our minds: “So where did the name Bluetooth come from anyway?”
As it turns out,
October 17, 2007Oct 17, 200710/17/07Hey, Scripting Guy! I have an Office Excel spreadsheet in which the last row in the spreadsheet sums all the rows above it. How can I add new rows (and new data) to this spreadsheet, making sure that the last row always sums up all the rows above it?—
