Microsoft Office Programmability Delivers for Consultant’s Customers

I’ve talked with with many dozens of customers here at TechEd 2010 about Office 2010 and shown them a lot of demos at the kiosk. As they arrive I hand them a t-shirt (hugely popular, btw). Very often the response is: “This is great. I actually do love macros and VBA”. I’m not surprised….


New Office VBA site launch on MSDN

MSDN now features a special site (also accessible via dedicated to Microsoft Office VBA – an important part of the Office 2010 value.   The site presents a clear path for technically savvy users to begin learning how to customize the Office applications to meet their needs. This new MSDN site highlights content for:…


Microsoft Office Developer Sessions from SharePoint Conference 2009 Now Live

Readers of the blog know that SharePoint Conference 2009 had some pretty memorable highlights. Now, we’re excited to announce that five key Office developer sessions are now freely viewable online. Here’s the list of sessions: What’s New in Office 2010 for Developers: This session gives you insight into the investments we’ve made in Office…


Office Developer Atlas Released

The Office Developer Atlas interactive training tool (built using Silverlight technology) is a great way for you to come up to speed on what developing productivity solutions with Office is all about. We’ve called it an atlas because it’s designed to give you a series of training segments that help you orient yourself in the…


Helpful Content Links for Getting Started with Office Development

I’m often asked for helpful content links for content around VBA, Microsoft Office Backstage view, and Ribbon. Here’s a collection: VBA Video Title URL Visual Basic for Applications Overview Getting Started with VBA in Office 2010 Getting Started with VBA in Excel 2010 Getting Started with VBA in Outlook 2010 Getting…


VBA in Office 2010 Articles Live!

We have published some new content about VBA in Office 2010: Getting Started with VBA in Office 2010 Getting Started with VBA in Excel 2010 Getting Started with VBA in Outlook 2010 Getting Started with VBA in PowerPoint 2010 We have an additional article, “Getting Started with VBA in Word 2010” that will be following…


VBA code I wrote this week in Excel and how it helped me

OK—my title is kind of colloquial. But I’m in a hurry, and the title conveys the idea well enough. Here’s the deal: I have a spreadsheet with a bunch of important data. But, some of the most distinctive data are all merged into one cell. To make the data more usable, I needed to parse…


Adding Event Code to Microsoft Office Backstage View Customizations

In my last post, I introduced the basic recipe of how to customize the Microsoft Office Backstage view. I showed how to set up the XML and where to place it. Now, we’ll take a look at how to add event code so that when a user interacts with your custom layout in the Backstage…


Customizing the Backstage view and Ribbon UI in Office 2010

One of the presentations I delivered at SPC 2009 was the title of this blog post. Don’t worry—I’ll be posting the video when it becomes available. And, we’ve got some MSDN content coming out before RTM that will show you the details around programming the Microsoft Office 2010 Backstage view and the Ribbon UI. Consider…