GitHub

Interacting with Xero API through VBA (Microsoft Excel)

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

LeanKit API Client for Excel and other Microsoft Office VBA or COM-based applications.

Public Sub TestCreateLeanKitCard() Dim lkClient As New LeanKit_API_ExcelHelper.Client Dim accountName As String Dim accountEmail As String Dim accountPassword As String Dim boardId As LongLong Dim ...
Houston Chronicle

How to Use .NET Class Library in Excel VBA

Your business's software developers can work with Microsoft's .NET framework to create powerful Excel macros for your spreadsheets. The .NET framework contains a vast library of classes that perform a ...
Microsoft

Excel VBA Performance Coding Best Practices

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