September, 2007

Hey, Scripting Guy! I have a bunch of Word documents that include fields like LastSavedBy. How can I write a script that retrieves the current values for these fields? -- OS Hey, OS. You know, the other night the Scripting Guy who writes this column...

Hey, Scripting Guy! I have a script that uses Netsh.exe to return information from my DHCP servers; all that information is then written to a text file. That works great, except that I need to be able to parse the data and pull out any IP addresses included...

Hey, Scripting Guy! How can I create a new folder in Microsoft Outlook? -- TY Hey, TY. You know, this is an exciting time here at Microsoft; after all, last night at midnight we officially released one of the most highly-anticipated software products...

Hey, Scripting Guy! I’m using an HTA as a data entry online form. The easiest way for me to format the HTA is to use a table; however, I can’t figure out how to let people type text into some of the cells in that table. How can I do that? -- EN Hey...

Hey, Scripting Guy! We have a bunch of Word documents that, for some reason, have been formatted using nothing but lowercase letters. We know exactly how we want to reformat these documents: all the headings (which are in 14-point type) should be in title...

Hey, Scripting Guy! My company has just created a new PowerPoint template, and has decided that we need to use this template for all our presentations. How can I apply this new template to all the presentations in my C:\Presentations folder? -- OI ...

Hey, Scripting Guy! I’m using an HTA as a drive-mapping application. I’d like to be clever about this and have the available drive letters appear in a list box. How can I dynamically show all the drive letters available on a computer? -- JT Hey, JT...

Hey, Scripting Guy! How can I count the number of users in an Active Directory group? -- TP Hey, TP. You know, it’s our sad duty to confirm that the reports currently sweeping the Internet are true. Without wishing to alarm anyone, we must admit that...

Hey, Scripting Guy! For various reasons, we don’t want our users storing “loose” files on their desktop. How can I write a script that will take all the files on the user’s desktop and, based on the file extension, move those files to the appropriate...

Hey, Scripting Guy! I have a text file which consists of individual fields separated by commas. I need to look at the second field in each line and, if it includes the word Everyone , I then need to take the sixth field in the line and write that value...

Hey, Scripting Guy! How can I read a text file until I encounter a specified phrase, then write that information to a new text file? I then need to repeat this process, reading the text file to the next instance of the phrase and then writing that information...

Hey, Scripting Guy! How can I determine which version of Windows Vista is installed on a computer? -- GC Hey, GC. You know, Microsoft is one of the largest and most successful companies the world has ever known. And yet, despite all our successes,...

Hey, Scripting Guy! How can I open an Excel spreadsheet, update all the links to other Excel spreadsheets, and then break those links? -- YH Hey, YH. Before we begin, we’d like to make an announcement: the Scripting Guy who writes this column gives...

Hey, Scripting Guy! How can I loop through a folder, open all the Excel files in that folder, then run a specified macro in each of those Excel files? -- BR Hey, BR. So, did you watch college football this past Saturday? In particular, did you watch...

Hey, Scripting Guy! How can I configure Internet Explorer 7 so it uses multiple home pages? -- PI Hey, PI. Just a second; before we begin, is anyone from Microsoft reading today’s column? Don’t be shy; raise your hand if you’re from Microsoft. No one...

Hey, Scripting Guy! How can I remove any line in a text file that contains the string f0 ? -- CJ Hey, CJ. Before we begin, we have a question for you : are you by any chance a serious player of online video games like EverQuest or World of Warcraft...

Hey, Scripting Guy! How can I backup an event log to a text file? -- IMBDS Hey, IMBDS. You know, the Scripting Guys have dedicated their lives to helping others. (Well, OK, originally we dedicated our lives to having others help us . But when no one...

Hey, Scripting Guy! How can I get a list of all the email addresses in my Sent Items and then write those addresses to an Excel spreadsheet? -- RD Hey, RD. As a matter of fact, yes, we are having problems focusing on work today. Granted, that’s true...

Hey, Scripting Guy! How can I add a background picture to an Excel worksheet? -- GA Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt … right before he eats...