Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

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.

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

Storing data in a structured way is important when that data will be read by a computer. One of the easiest ways to put data into an easy-to-read format is with a comma-separated value (CSV) file. A ...

Microsoft Windows PowerShell has been a long time coming. Windows has never enjoyed the powerful shell scripting environments that its Unix rivals have long included. That’s changed now with the ...