We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...

In my previous post, I showed you how to create a clickable button in Excel. That button displayed a simple message box. Now, I want to show you how to use the button to kick off a PowerShell script.

You can use PowerShell scripts to automate various tasks in Windows and other operating systems, like organizing data, searching for files or fetching data from the Internet. You can't actually run ...

A single pipeline replaced fourteen lines and I never looked back.

I advise against it. But if you must use a logon script to authenticate, here's how to get it done with PowerShell. In my PowerShell training classes or at conferences I inevitably face the question ...

PowerShell scripts reduce the effort in running repetitive tasks. If you frequently execute scripts at pre-defined times or specified time intervals, you may want an efficient way of not having to ...

My Downloads folder has become the Wild West. I have dozens (okay, hundreds) of different files that accumulate on a monthly basis. These include heaps of generically named screenshots, random PDF ...

Ever wonder how long a piece of PowerShell code takes to execute? Maybe you've got a script that occasionally gets hung up on some process, and you'd like a way to terminate the script if it takes too ...