Showing archive results for 2006

Hey, Scripting Guy! How can I delete all the email sent from a specific person?-- VP Hey, VP. Ah, yes, deleting email from a specific person; that’s something we Scripting Guys are all too familiar with. For example, the first time the Scripting Guys ever heard of such a thing was back in the early days of Microsoft Mail, when Bill Gates suppose...

Hey, Scripting Guy! How can I read lines 56 to 62 in one XML file, and replace those with lines 56 to 62 taken from another XML file?-- JA Hey, JA. First of all, we’d like to thank you for your question; in addition, we’d like to welcome you and everyone else to today’s Open House in honor of the 501st Hey, Scripting Guy! column. We know that – ...

Hey, Scripting Guy! Suppose I get a date-time value in UTC format. How can I subtract x number of days from that value?-- MW Hey, MW. First of all, we’d like to thank you for your question; in addition, we’d like to welcome you and everyone else to today’s Open House in honor of the 500th Hey, Scripting Guy! column. We know that a few of you are...

Hey, Scripting Guy! How can I tell if a specified worksheet exists in an Excel workbook?-- MVK Hey, MVK. Back when he was in high school (that was about 3 or 4 years ago, of course), the Scripting Guy who writes this column was kind of half-watching a variety show on TV. The show featured a man and his dogs: “The Smartest Dogs in the World!” The...

Hey, Scripting Guy! How can I set the default printer based on the IP address of the computer?-- TT Hey, TT. You’ll have to forgive us for being a little distracted this morning. Last night the Scripting Guy who writes this column went to the gym with his 16-year-old son. For the first time ever, the Scripting Son was able to bench press more th...