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…
Year: 2006
How Can I Extract Information Located Between Two Known Values in a Text File?
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…
How Can I Map a Drive, Copy a File to That Drive, and Then Unmap the Drive?
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?…
How Can I Change the Default Highlight Color for a Microsoft Word Document?
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…
How Can I Use Windows PowerShell to Get a List of All My Computers?
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…
How Can I Create a Custom Date Format in Microsoft Excel?
Hey, Scripting Guy! In Microsoft Excel, how can I display a date like 01/20/2006 using this format: 20060120?– CM Hey, CM. Who do we make the check out to again? And for how much? Oh, sorry. After attending a parent meeting for the Scripting Son’s new baseball team the Scripting Guy who writes this column…
How Can I Separate Hours and Minutes in a Date-Time Value?
Hey, Scripting Guy! In determining system uptime I get back a value like 65.75 hours. How can I convert this value to “65 hours and 45 minutes”?– JM Hey, JM. We’ll see what we can do for you, but we have to be honest: this is a very sad day for the Scripting Guys. Thanks…
How Can I Extract the Text Between the Header and Footer in a Text File?
Hey, Scripting Guy! How can I extract the text between the header and footer in a text file?– LL Hey, LL. Before we answer your question we should point out that, depending on when you’re reading this, you might be missing Day 1 of Windows PowerShell Week. Even as we speak the lovely and talented…
How Can I Run a Macro After Opening Up Word?
Hey, Scripting Guy! How can I run a specified Word macro after opening Word using a script?– JD Hey, JD. You know, when they first tested the atomic bomb a number of physicists had legitimate fears that the bomb might set off an unstoppable chain reaction that would end up destroying the entire world. We…
How Can I Enable System Restore Using a Script?
Hey, Scripting Guy! How can I enable Windows XP’s System Restore using a script?– RL Hey, RL. Thanks for the question; the Scripting Guy who writes this column is running way late today, the clock is ticking, and he was desperately in need of a question a he could answer without having to use a…