Marcelo's WebLog

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

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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 Live blog has...
  • Blog Post: 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: http://blogs.office.com/b/office_blog/archive/2010/09/23/office-web-apps-reach-20-million-new-features-today-7-more-countries.aspx . Try out the...
  • Blog Post: 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...
  • 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: 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...
  • 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 (10 items)