BUG: “Old format or invalid type library” error when automating Excel (Christin Boyd)

A customer recently reported this bug when running their Shared Addin for Excel on French Windows.  Error: 0x80028018 (-2147647512) Description: Old Format or Invalid Type Library His solution worked great on English Windows, but gave errors in any other language.  This is a known problem in Excel and there are a few workarounds that work… Read more

TechEd Sessions on Office Development

If you’re going to TechEd in Los Angeles next week, then don’t miss these four sessions: DTL03-INT Meet the Microsoft Visual Studio Team Christin Boyd, Eric Carter, Paul Yuknewicz, Jay Schmelzer, Dustin Campbell, Jonathan Aneja, Luke Hoban, Igor Zinkovsky, Faisal Nasir, Harry Pierson, Lisa Feigenbaum Mon 5/11  2:45 PM-4:00 PM | Blue Theater 1 OFC325 … Read more

New "How Do I" Video on Creating Smart Tags in Word (Beth Massi)

Our very own Mary Lee has got a new video up on the Dev Center on programming smart tags in with custom recognizers in Word using Visual Studio 2008 Service Pack 1. This is a video version of the How To topic in the MSDN library. Watch or download the video here. Thanks Mary! Enjoy,–Beth… Read more

DevConnections Conference: VSTO Session Demos (Christin Boyd)

Hi Folks!  If you’re not one of the 4,000 professionals attending DevConnections in Las Vegas, then never fear!  You can see my demos and learn about my session “Office Development with Visual Studio 2008” from this blog entry!  VS 2008 lets you target Office 2003 or Office 2007.  We recommend that you only install one… Read more

How Do I: Add Smart Tags to Excel Workbooks? (Kathleen McGrath)

With the release of Visual Studio 2008 SP1, you can now add smart tags to Excel by using an add-in.  In this video, I show you how to add them to both a document-level customization and an add-in project. How Do I: Add Smart Tags to Excel Workbooks? This video is based on the topic:… Read more

Create an Excel Shortcut Menu That Writes Selected Values to a Text File (Harry Miller)

It doesn’t take much code to add a command to a shortcut menu in Excel, but the menu objects have strange names so it’s not intuitive, to me at least. The trickiest part is just sorting out how it’s supposed to work, because it seems like it should be different from adding buttons to toolbars,… Read more

Peek at Service Pack 1 (Christin Boyd)

Visual Studio 2008 Service Pack 1 is not finished yet, but we do have a beta version of the documentation ready for you to read!  You can learn about some of the features that you’ll see later this year when we release SP1.  I recommend starting with reading about a totally new feature that we… Read more

Calling Into A VSTO Add-in From a COM Smart Tag (McLean Schofield)

My last post explained some of the differences between VSTO smart tags (that is, smart tags that you implement in a document-level solution for Word or Excel by using VSTO) and COM smart tags (that is, smart tags that you create by implementing COM interfaces provided by the smart tag SDK). If you are using… Read more

Databinding best practices for Excel (Christin Boyd)

I read a question on the forum about databinding in an Excel solution.  The developer was asking about Excel 2003, but the answer I wrote will work for both Excel 2003 and Excel 2007.  Here’s the question:  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3122341&SiteID=1&mode=1 As a best practice you can create one dataset in ThisWorkbook designer and then programmatically reference it… Read more

Deploying an Office solution using Windows Installer (Mary Lee)

Visual Studio 2008 offers a ClickOnce deployment experience for solutions developed for the 2007 Microsoft Office system.  However, if you want to deploy additional files, add extra registry keys, or use SMS, you may still be interested in creating a Windows Installer package. Here are the very basic steps to configure your setup project: 1…. Read more