MSDN now features a special site (also accessible via www.iheartmacros.com ) 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...

When I was a consultant my customers ranged from small companies to big Fortune 100 enterprises. No matter where a business fit in the spectrum I encountered a lot of Office solution code. But, it was sometimes difficult to figure out how many solutions were in play within an organization. And, as new...

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 http://msdn.microsoft.com/en-us/isv/bb190543.aspx Getting Started...

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...

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 the data elements...

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 view, custom code fires...

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...

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...

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 employ...

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...

You might be tempted to think that, given that I’m so-called “insider” I’d know all about everything in Office 2010. But, the fact is that there is so much to the products in Office that few people can know it all and know it early. So, this brings me to when I was recently demo’ing Office 2010 and...

Buckle in! This is a full-throttled post! If you’ve been following the press and the excitement around our partner conference (WPC) this week you have heard that we have opened up the treasure-house of information regarding Office 2010 . I’m going to give you some information about what is new in terms...

So, I just bought 5 copies of Office 2007 for a friend of mine in the good land of Minnesota. He’s upgrading all of his home computers and those for his kids scattered about the country. One of the first things he’ll notice is the new Office Fluent UI, and he’ll likely need some help finding his way...

As I spent a ton of time at Tech Ed, I was super impressed by the immense amount of interest in Office 2010. I know the excitement will only grow, and one of the best ways for you, the devoted Office Developer, to get inside, in-depth, in-person exposure to all things Office 2010 and SharePoint is at...

TechEd 2009 is a done deal. I wanted to toss out a few observations from the event. Here’s what really stood out: 1) The overall mood was pleasantly up-beat and the attendance was solid. The economic times have hit every budget everywhere, but the tempo was not sagging at TechEd. I heard a number...