How Can I Close a Command Window with a Specific Title?

Hey, Scripting Guy! How can I use WSH to close a command window with a specific title?— MF Hey, MF. You know, some things are just really hard to believe, regardless of whether or not they happen to be true. For example, according to the Big Bang Theory the entire universe was created when a… Read more

How Can I Set Word’s Revision View Mode to Final?

Hey, Scripting Guy! In Microsoft Word 2003, my documents open as Final Showing Markup. How can I change this so the default view is Final?— CD Hey, CD. You know, this is the first Hey, Scripting Guy! column we’ve written since returning from the Thanksgiving holiday. After four days of eating, football, eating, basketball, and… Read more

How Can I Rename Files Like _JKG1234.jpg to 272_DSC_1234.jpg?

Hey, Scripting Guy! How can I rename files like _JKG1234.jpg to 272_DSC_1234.jpg?— NA Hey, NA. You know, NA, we feel sorry for you. Why? Well, on the one hand you’re unbelievably lucky. After all, the Scripting Guys never write scripts that they actually use, yet you somehow managed to hit upon an exception. Talk about… Read more

How Can I Get a List of All the Groups Whose Name Starts with G-S-Group?

Hey, Scripting Guy! How can I use wildcards to get a list of all the groups whose name starts with G-S-Group? — JD Hey, JD. It’s the day before Thanksgiving, and one of the Scripting Guys is headed out of town as soon as he finishes his Hey, Scripting Guy! column. And what a coincidence:… Read more

How Can I Sort Worksheets in a Workbook?

Hey, Scripting Guy! How can I sort worksheets in a workbook?— FS Hey, FS. How can you sort worksheets in a workbook? Well, to tell you the truth, not as easily as we had hoped you could sort worksheets in a workbook. This doesn’t mean it can’t be done; it just means that the process… Read more

How Can I Lock a Workstation After Five Minutes of Inactivity?

Hey, Scripting Guy! How can I lock a workstation after five minutes of inactivity, something recommended to us by our auditors?— NM Hey, NM. To tell you the truth, we don’t know. Locking a computer remotely can be a bit of a problem; for more information on that, take a look at one of our… Read more

How Can I Verify that ADAM is Installed?

Hey, Scripting Guy! How can I verify that ADAM is installed?— CW Hey, CW. Although former President Ronald Reagan is usually given credit for the phrase “Trust but verify,” we’ve always thought that sounded more like the sort of thing a system administrator would say: “Of course I trust you when you say you installed… Read more

How Can I Import a Fixed-Width File into Microsoft Excel?

Hey, Scripting Guy! How can I import a fixed-width file into Microsoft Excel?— JP Hey, JP. We have a confession to make here, something we’re terribly ashamed of: for a moment – just for a moment, mind you – we doubted Microsoft Excel. Yes, we know: how could we do such a thing? All we… Read more

How Can I Determine the Height and Width of a Picture File Without Using Windows Media Player?

Hey, Scripting Guy! Awhile back you showed us a method to determine the height and width of a picture file. However, that solution required us to import all our picture files into Windows Media Player. Isn’t there another way to get this information, one that doesn’t require Windows Media Player?— RP Hey, RP. You see,… Read more

How Can I Use ADO to Read a Text File Where All the Data is on a Single Line?

Hey, Scripting Guy! I have a fixed-width text file which includes first name (6 characters), last name (13 characters), and department (9 characters) all on a single line. How do I read that using ADO?— DW Hey, DW. Well, to be perfectly honest, we don’t think you can read a file like this using ADO… Read more