Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: VSTO Bug Tracker (Eric Carter, Beth Massi)

    Eric Carter released a sample and series of articles based on his TechEd demo last week that shows you how to bring bug data from TFS into Excel and Word using VSTO so it can be further analyzed. If you you went to TechEd but missed the session you can watch it here if you’ve registered: Advanced Microsoft...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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: How to: Add...
  • Blog Post: 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, but it...
  • Blog Post: I Just Want to Format a Cell in My Excel Worksheet (Norm Estabrook)

    So you just want to write some code to format a cell in a worksheet. However, there isn't a help topic in sight that shows you how to do it. There may be a topic out there, but you don't have time to sift through the web searching for it. You're not alone. The forums are filled with questions about how...
  • Blog Post: 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 put into...
  • Blog Post: 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...
  • Blog Post: Visual Studio Command Bar for Arranging Controls on Documents and Worksheets (McLean Schofield)

    One of the lesser-known features of Visual Studio Tools for Office is the Microsoft Office Word and Microsoft Office Excel command bar. When you are developing a document-level project for Word or Excel (for example, a Word Document or Excel Workbook project) and you have the document or one of your...
Page 1 of 1 (14 items)