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...

Hey, Scripting Guy! How can I remove all the non-alphabetic characters in a string? -- CD Hey, CD. You know, typically the Scripting Guys don’t play favorites; we treat all our readers and all the questions we receive exactly the same. (OK, so, technically...

Hey, Scripting Guy! I understand that, in Windows Vista, I can write a script that will cause a scheduled task to immediately execute. How do I do that? -- KW Hey, KW. Before we answer today’s question, we’d like to take a moment to say a few things...

Hey, Scripting Guy! How can I “rotate” a text file 180 degrees? I need the last line in the file to become the first line, the first line in the file to become the last line, and all the lines in between to switch places as well. -- BJM Hey, BJM. You...

Hey, Scripting Guy! How can I get a list of my appointments for a specific month (for example, all my appointments for December, 2007)? -- HG Hey, HG. We’ll get to your question in just a moment. Before we do that, however, the Scripting Guy who writes...

Hey, Scripting Guy! How can I find all the files in a directory tree that contain a specified phrase? -- PB Hey, PB. OK, so picture this: for the first time in a couple of months, the Scripting Guy who writes this column and the Scripting Son are playing...

Hey, Scripting Guy! We have a spreadsheet where people enter a bunch of data. In order for this data to be used in another application, none of the values can exceed 999; if we have a value like 1234, that’s supposed to be entered as 999, the maximum...

Hey, Scripting Guy! I need to check the size of a folder once every hour; if the folder has exceeded a specified size, I then need to delete the oldest file in that folder. How can I do that? -- JC Hey, JC. You know, a lot of you are thinking, “Gee...

Hey, Scripting Guy! How can I get the GUID for a user account if all I know is the user’s logon name and domain? -- IU Hey, IU. You know, one of the great things about the Scripting Guy who writes this column is – well, OK, right off the top of our...