Scripting Blog [archived]

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

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 Use Windows PowerShell to Pull Records From a Microsoft Access Database?

(image) Hey, Scripting Guy! How can I use Windows PowerShell to pull records from a Microsoft Access database?-- SB(image) (image) (image) Hey, SB. You know, you’re lucky to get this question answered; after all, this looks as though it’s going to be the very last Hey, Scripting Guy! column ever. To be honest, that came as a bit of a ...

How Can I Run a Windows PowerShell Script from the Run Dialog Box or a Shortcut?

(image) Hey, Scripting Guy! How can I run a Windows PowerShell script from the Run dialog box or from a shortcut? In the Run dialog box I type something like c:\scripts\test.ps1 but my script just opens up in Notepad.-- RS(image) (image) (image) Hey, RS. We have just one thing to say: University of Washington 29, UCLA 19. And this after ...

How Can I Use Windows PowerShell to Automate Microsoft Excel?

(image) Hey, Scripting Guy! How can I use Windows PowerShell to automate Microsoft Excel?-- MW(image) (image) (image) Hey, MW. Yes, it’s true: the week of November 6-10, 2006 will be Windows PowerShell Week on TechNet, with the Scripting Guys presenting a series of webcasts (one each day, Monday through Friday) designed to introduce you ...

How Can I Use Windows PowerShell to Locate All the .WMA Files on My Computer?

(image) Hey, Scripting Guy! How can I use Windows PowerShell to locate all the .wma files on my computer?-- LC(image) (image) (image) Hey, LC. Harry Potter. Hogwarts. Ron Weasley. Dumbledore. Quiddich. What’s all that about? Oh, nothing: just a few words that idly floated through the head of the Scripting Guy who writes this column. And ...