Showing archive results for 2006

Hey, Scripting Guy! How can I add a bunch of rows to an Excel spreadsheet and then stick a total row at the bottom?-- MW Hey, MW. Could we ask you a favor: is there any chance that you could write back later with this question? As you may or may not know, the University of Washington men’s basketball team is hosting a four-team, round-robin tourna...

Hey, Scripting Guy! In a text file, how can I extract the information that appears between the string HOSTNAME= and a blank space?-- B Hey, B. You’ll have to pardon us if we seem a little sluggish today; we’re still recovering from all the fun and excitement of Windows PowerShell Week. What if you missed out on Windows PowerShell Week? Well, then ...

Hey, Scripting Guy! How can I map a drive, copy a file to that drive, and then unmap the drive?-- ZK Hey, ZK. You know, sometimes these questions are difficult for us to answer, simply because we don’t usually find ourselves performing the task being asked about. Remove every other line in a text file? Well, we’ve never done that, but we can proba...

Hey, Scripting Guy! How can I change the default highlight color for a Microsoft Word document?-- TW Hey, TW. You know, any time the Scripting Guy who writes this column wants to terrify the Scripting Son, he tells the blood-curdling saga of the first TV the Scripting Dad remembers: a TV that showed everything in black-and-white only! Granted, tha...

Using Windows PowerShell, how can I retrieve a list of all the computer accounts in my domain?-- TE Hey, TE. You know, several years ago the Scripting Guy who writes this column was playing basketball with one of his brothers. Because there were a total of 5 people at the park they had to play 2-on-2, with one person forced to sit out. After a sho...