Howdee Excel Ninjas! My article on using VBA to import JSON into Excel has been one of my most popular. As a follow up to this I wanted to demonstrate how to Parse JSON using VSTO (Visual Studio Tools for Office) add-in to help perform...
Filtering data in Excel is one of the most common practices for accountants, analysts, executives, and everyone in-between. Using Excel’s built-in Filter tool is a necessary skill for almost anyone in an office environment, but sometimes the user interface and efficiency of the filter can...
Howdee! A common requirement when developing in Excel is the need to have code run while a user interacts with a report. That is to say, the user does not need to explicitly trigger your subroutine. Therefore, today I want to cover how to run...
Howdee! I can’t believe it’s finally here. This blog has been a long time coming for me. For the longest time after deciding to start an Excel blog I struggled with choosing a topic that would attract and interest readers. Which topic from my list...
 |
Tickets |