Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

How Can I Connect to the Junk Mail Folder in Outlook?

(image) Hey, Scripting Guy! Over the past year or so you’ve answered several questions in which you use a script to connect to the Inbox in Microsoft Outlook. But how can I connect to the Junk Mail folder in Outlook?-- ME(image) (image) (image) Hey, ME. Let’s see, what time is it? OK good: we have enough time to answer this question ...

How Can I Use Windows PowerShell to Delete All the .TMP Files on a Drive?

(image) Hey, Scripting Guy! How can I use Windows PowerShell to locate and delete all the .tmp files on a drive?-- OR(image) (image) (image) Hey, OR. You know, there’s an old saying: Give a man a fish and he’ll eat for a day; teach that man to fish and he’ll eat for the rest of his life. Well, unless he’s like the Scripting Guy ...

How Can I Print a Microsoft Access Report?

 (image) Hey, Scripting Guy! How can I print a Microsoft Access report?-- RW(image) (image) (image) Hey, RW. You know the cool thing about being a Scripting Guy – aside from the opportunity to pal around with Paris and Nicole – is the fact that people think we know what we’re doing. Someone asks a question like, “How can I ...

How Can I Tell Whether a Number is Even or Odd?

(image) Hey, Scripting Guy! How can I tell whether a number is even or odd?-- JO(image) (image) (image) Hey, JO. You know, just this morning the Scripting Guy who writes this column was driving in to work when he heard an advertisement for a store that sells HD TVs. “We don’t confuse you by stocking all the different HD TVs available...

How Can I Split a String Only on Specific Instances of a Character?

(image) Hey, Scripting Guy! I have a series of string values that I need to convert to an array, splitting the value on the ampersand (&). However, if the ampersand is followed by amp (in other words, if the string is &amp) I don’t want to split the string at that point. How do I do that?-- AK(image) (image) (image) Hey, AK. We ...