Marcelo's WebLog

Improving the world one entity at a time (now tweeting on @mlrdev)

Browse by Tags

Tagged Content List
  • Blog Post: 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 the...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 object, and wrote out...
  • Blog Post: 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...
Page 1 of 1 (5 items)