Office Development with Visual Studio Tutorial Series – Part 3 (Beth Massi)

A couple months ago Robert Green, VSTO MVP, started a series of tutorials on building on Office 2007. Yesterday we published part 3 of his step-by-step tutorials. Thanks Robert! In this third part of the series of tutorials on Office Business Applications, learn how to create an Excel 2007 solution using Visual Studio 2008 that… Read more

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

Video How Do I: Add Controls at Run Time in an Application-Level Project (Mary Lee)

In Walkthrough: Adding Controls to a Worksheet at Run Time in an Application-Level Project, you can see  to add host controls at run time in an application-level add-in by using Visual Studio 2008 SP1.  This video is posted to the How Do I Videos – Visual Basic page, part of the Visual Basic Developer Center…. Read more

Why Can’t I Change the Update Path when Redeploying VSTO Solutions? (Christin Boyd, Kris Makey, Jeff Young)

The other day I was asked about the automatic Updates feature of VSTO 3.0 deployment.  In this scenario, he used the Publish Wizard in VS 2008 to create a Word document solution and the install manifest.   Then a bunch of people used the Word document, and kicked off the installer which then copied things to… Read more

How Do I: Deploy Document-Level Office 2007 Solutions with Windows Installer? (Mary Lee)

In Deploying an Office solution using Windows Installer, you read how to deploy document-level Office 2007 solutions with Windows Installer.  As a follow up, you can now see how to add a Setup project to your VSTO solution and add a custom action to update custom document properties. This example uses Excel 2007, but you… Read more

How Do I: Deploy Application-Level Office 2007 Solutions with Windows Installer? (Mary Lee)

In Deploying an Office solution using Windows Installer, you read how to deploy application-level Office 2007 solutions with Windows Installer.  As a follow up, you can now see how to add a Setup project to your VSTO solution and create registry keys. This example uses Excel 2007, but you can apply these principles to any… 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