This VBA script allows access and interaction with the Xero API through Microsoft Excel. It handles the authentication process (OAuth2) and the interactions with the API. The Xero API has robust ...

This documentation describes the required steps to create a function in Excel that will: receive input (as range) build the API call using the input variables receive API results, parse JSON, and ...

Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance. I want to start off this post by thanking everyone ...