Microsoft Office 365 is now available!

Personally, I think that having some storage and Office Web Apps is a great combination on its own. The fact that you also get mail & calendar (including Outlook Web Access), SharePoint Online, Lync Online, and Forefront protection, makes this an unbelievably awesome package. I think this is delivering on the “help realize potential” mission…


OneNote Mobile, now on the iPhone

As a huge OneNote fan, I’m always happy to see my notebooks accessible in more and more places. It might even prompt some folks to update the OS on their devices, as it requires the iOS 4.2 upgrade (which is just a software upgrade, this should work on an iPhone 3 as well). The Windows…


Embedding PowerPoint and Excel docs in your blog

Just saw this today, and I think it’s insanely cool how PowerPoint and Excel docs that I have shared online can be embedded in blog posts and web pages: Try out the Excel Body Mass Index calculator and watch the chart update… very cool indeed. Enjoy!


Bookmarklet to find OData service for SharePoint site

As you probably already know, SharePoint has great support for OData, providing access to lists, documents and all sorts of goodies. I always seem to forget how the link to the OData endpoint is constructed, though. So I created this short bookmarklet that does the trick. Just navigate to a SharePoint site and click on…


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…


InfoPath and SharePoint = sophisticated automation without code

Today I want to talk about how InfoPath and SharePoint allow non-developers to develop some very sophisticated systems. Someone I know was just stepping into a new job, a startup-like organization currently in the process of defining many of their internal business processes. In particular, the process the new person was in charge of was…


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…