Showing archive results for 2007

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 as the Washington Huskies dismantled Boise State 24-10, snapping the Bronco’s nation’s-best winnin...

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, not a single Microsoft employee is reading today’s column? Excellent. What difference does it ma...

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? Admittedly, none of the Scripting Guys play these games; we still find Pong to be a little over-stim...

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 seemed very interested in that we changed our minds.) That means that, on those rare occasions when...

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 most days. However, at least today it’s understandable, coming on the heels of a very exciting (an...