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:…


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…


Office 2010 Developer at SPC & “What’s the end-user value?”

Whew! What a week at the SharePoint Conference! Let me re-cap some highlights for you and talk for a moment about “Real User Value”. On Monday, I delivered a session called “What’s New in Office 2010 for Developers”. It was very well attended, and the demos came through 100%. I laid out the investments we…


Why VBA Still Makes Sense

Not infrequently I am asked, “So, should I use VBA? Is it going to be around in Office 2010? Is it supported? Should I migrate away from VBA now? Can I count on this technology?” (Here I go with a response!) These are fair questions, because customers need to know that the software systems they…


Office Developer Guild is Live!

The developer community for Microsoft Office grand and healthy. And, the knowledge and expertise in our community is pretty vast and deep. To make it easier for us to stay alert about events, up-coming content, etc. and more easily share ideas we now have the “Office Developer Guild”—a group of like-minded professional friends on Facebook….