Showing archive results for 2007

Hey, Scripting Guy! How can I determine the home directory for all the disabled user accounts in Active Directory?-- DB Hey, DB. You know, it’s not like the Scripting Guy who writes this column is addicted to TV or anything, but last night he was watching TV (as usual) when he saw a brief feature on a new device that will scramble eggs for you. ...

Hey, Scripting Guy! How can I ensure that a script runs only once on a computer?-- ML Hey, ML. You know, we were going to start off today’s column by saying, “Show us your bobbleheads!” However, we didn’t want to have to explain to Microsoft people that there was nothing risqué or offensive in that statement; instead, all we wanted is to see wha...

Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet?-- NN Hey, NN. Please excuse any bloodstains that might appear on your screen; as it turns out, the Scripting Guy who writes this column was involved in an … incident … this past weekend. Ah, but dedicated Microsoft employee that he is,...

Hey, Scripting Guy! I have about 400 log files in a folder. I need to go in and remove the first 5 lines from each of those log files. How can I write a script to do that?-- JW Hey, JW. Before we begin we need to issue a clarification. A few days ago we reported that the Scripting Guy who writes this column had thrown a basketball the length of ...

Hey, Scripting Guy! How can I assign a background color (based on a specified value) to a spreadsheet cell and then “sum” those cells?-- JC Hey, JC. Thanks for the question. And yes, you heard correctly: in his last game the Scripting Son did indeed go 4-for-4, banging out three singles and a double. That outing raised his batting average for th...