A place to learn about PowerShell and share stories of automation
November 30, 2005Nov 30, 200511/30/05Hey, 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,
November 29, 2005Nov 29, 200511/29/05Hey, 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.
November 28, 2005Nov 28, 200511/28/05Hey, 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,
November 23, 2005Nov 23, 200511/23/05Hey, 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,
November 22, 2005Nov 22, 200511/22/05Hey, 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.
November 21, 2005Nov 21, 200511/21/05Hey, 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;
November 18, 2005Nov 18, 200511/18/05Hey, 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 ADAM on that computer.
November 17, 2005Nov 17, 200511/17/05Hey, 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.
November 16, 2005Nov 16, 200511/16/05Hey, 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,
November 15, 2005Nov 15, 200511/15/05Hey, 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,
