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

Millions of small businesses all around the world use Microsoft Word and Excel daily to create correspondence or crunch numbers. If you are like many small business owners, there are probably plenty ...

How to open and populate an Outlook appointment from inside Excel using VBA Your email has been sent It’s easy to import data from Excel into an Outlook item, such as a message or appointment, because ...

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

A super easy way to generate new records from multi-value columns using Excel Power Query Your email has been sent Have a complex Excel problem? Power Query to the rescue! Analyzing data often means ...