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

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

While software can sync files and folders for you, it's often limited in scope. Learn how a PowerShell script can help you build a custom solution.

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.

Background Intelligent Transfer Service is a useful tool for transferring large files or transferring to a system with connectivity issues. Performing simple file copies with PowerShell is fairly ...

I have PDFs in a directory that I would like to sort based on a portion of their filename. I've come up with a solution (cobbled together from Google searches) that mostly works but am wondering if ...

Before you can change an ACL, you must get the current one. There are two ways to do this with PowerShell. Learn how to get the current ACL and modify it.