When coding in a script, or even in a fully-featured software application, it's important to account for as many scenarios as possible. To limit the number of possible scenarios, it's a best practice ...

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.

When you write a PowerShell script, you are creating something that might be executed by someone else on a totally different computer. A potential obstacle is that the person running your script may ...

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 ...

Learn how to design and build your own interactive menus inside your PowerShell scripts. This will help non-PowerShell users easily navigate and use them.

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 ...

Lets say I'm going to have 50 various PowerShell scripts to do "stuff".<BR><BR>All of this work is being done for a single application and that application uses 3 different SQL Server 05 (soon to be ...