When you hear Excel automation, it’s easy to assume it refers only to those complex, or even basic, VBA scripts and macros that seem too intimidating to edit or reuse. However, with any real, ...

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