Missing function for OData and Office

The last entry of Consuming OData with Office VBA series had a small glitch – one of the helper functions is missing. The code isn’t too tricky to write, but it’s a handy little thing to have in your VBA toolkit. It simply takes a collection of dictionaries, and returns a new collection with all…


Consuming OData with Office VBA - Part IV (Access)

Check out parts one, two and three if you haven’t – good stuff there! In today’s post, we’re going to import data into Microsoft Access. I’m going to focus on having the building blocks in place, although in real-life use, you would either make this more general or more specific – more on this later….


Consuming OData with Office VBA - Part III (Excel)

This is part three of a series – you should read part I and part II to have the code snippets handy and follow along. Today we won’t be doing anything special with OData itself, instead we’ll see how the snippets work across different Microsoft Office products. Just start up Excel, paste in the OData…


Consuming OData with Office VBA - Part II

In case the title didn’t give the fact away, this is the second part of a series – the first part is here. This post builds on the code from that post, so make sure you’ve gone over that before continuing. Last time, we simply got an XML document in the form of a DOMDocument…


Consuming OData with Office VBA - Part I

This post is the first of a series describing how you can leverage OData information in your Microsoft Office documents and applications using Visual Basic for Applications (VBA). If you’re using the newer programming APIs based on the .NET Framework, then you have plenty of support for OData in the form of the ADO.NET Data…