JavaScript isn't replacing Office macros anytime soon, but the Office Web apps (and the SharePoint-based enterprise equivalents) are improving regularly. For users that means simple but useful ...

Before we go further, it is important to note that this is just a proof of concept and to even use custom functions in Excel, you first need to be using the Office Insider version of Excel and to ...

At the Build 2018 developer conference that's taking place these days in Seattle, USA, Microsoft announced support for custom JavaScript functions in Excel. What this means is that Excel users will be ...

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

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.

How to run script in Microsoft 365 Excel for the web Your email has been sent The ability to automate tasks in Excel for the web has been a long wait—but it’s ...

At its Ignite conference, Microsoft today announced an update to Excel that brings a new JavaScript API to the venerable spreadsheet app. With this new API, developers will be able to create custom ...

The questions plaguing users of Microsoft Excel—JavaScript support, slow Mac development cycles, the lack of Easter eggs—all apparently come down to one thing: prioritizing developer resources. The ...

I have a set of spreadsheets where the data (text) is color-coded by row. Would it be feasible to write a formula or script to count how many of what color rows are spread across the workbooks in my ...