.NET4Office

A blog by Eric Carter

  • .NET4Office

    How VSTO solves the Excel LCID or Locale issue in the June CTP build

    • 4 Comments
    The June CTP of Visual Studio 2005 is now live on MSDN. In this build, you will find that VSTO has added a feature to address the Excel LCID or Locale issue. What is the Excel Locale issue? Well, if you run a VSTO customization for Excel on a machine...
  • .NET4Office

    VSTO Smart Tag Terms

    • 1 Comments
    VSTO smart tags let you easily create a smart tag by adding some terms to it. For example, consider this simple smart tag in a VSTO worksheet project item. It creates a smart tag that recognizes the term "Halibut". One caveat about using the terms collection...
  • .NET4Office

    I'm looking for a strong developer to work on my team creating the next version of VSTO

    • 1 Comments
    I'm looking for a strong developer with C++ & C# skills to work on the next version of VSTO. I am the hiring manager for this position. Submit your resume via my contact link: http://blogs.msdn.com/eric_carter/contact.aspx Visual Studio Tools for...
  • .NET4Office

    Even More Misha Cat: Why are the number of Actions in VSTO's Smart Tag feature fixed?

    • 0 Comments
    Misha also worked on the VSTO Smart Tags feature. I recently asked him this question: Eric: One aspect of the smart tag design seems pretty strange to me: Why do you have to do this: SmartTag mySmartTag = new SmartTag(" http://smarttags.me.com#fish...
  • .NET4Office

    Check out this Outlook VSTO video

    • 1 Comments
    Kathleen has created yet another awesome video, this time showing VSTO's new support for Outlook. Her demonstration shows you how to use the new Microsoft Office Outlook add-in project feature in Microsoft Visual Studio 2005 Tools for the Microsoft...
  • .NET4Office

    VSTO Book Announcement--Sample chapter covers VSTO's new support for Outlook

    • 1 Comments
    More exciting announcements! Eric Lippert and I have just completed writing a book on VSTO that will be in the Addison-Wesley .NET Series--it is coming out this fall. You can read a sample chapter that covers VSTO's new support for Outlook here: ...
  • .NET4Office

    VSTO support for Outlook

    • 7 Comments
    Steve Ballmer announced VSTO support for Outlook add-ins in his Tech-Ed keynote today. This is exciting news--VSTO Outlook add-ins solve all the problems people have encountered while trying to build managed COM add-ins for Outlook using IDTExtensibility2...
  • .NET4Office

    More Misha Cat: Why did we use the wrap approach rather than the extends approach for Actions Pane

    • 4 Comments
    Continuing my series of interviews with Misha Shneerson. Eric: Why did we use the "wrap" approach for ActionsPane instead of the "extends" approach? VSTO uses two models to provide additional functionality on top of the Office object models. In...
  • .NET4Office

    ActionsPane AutoRecover and Clear

    • 1 Comments
    Misha Shneerson--also known as "Misha-Cat" and "founder of ActionsPane" recently answered some questions I had about ActionsPane. To preface this, VSTO's support for ActionsPane actually attaches a Smart Document solution to the Word or Excel document...
  • .NET4Office

    'missing' in action with C#

    • 1 Comments
    When programming in C#--if you want to omit an optional parameter for a method in the Excel object model, you have to pass System.Type.Missing to the parameter: myExcelApp.MethodWithOptionalParameter(System.Type.Missing); When you want to omit an...
  • .NET4Office

    The assembly * could not be found...

    • 2 Comments
    An internal user of VSTO asks: Why can't we give an error message like "Visual Studio 2005 Tools for Office is not installed" instead of the meaningless ""The assembly * could not be found at or could not be loaded..."? The meaningless error message...
  • .NET4Office

    A Beta 2 VSTO Issue you may encounter in VB.NET: Me.Range("A1") throws a COMException

    • 0 Comments
    In Beta2 we shipped with an unforunate bug that will affect VB.NET users. If you write code like this in a worksheet project item, it will fail with a COMException at runtime: MsgBox(Me.Range("A1").Value) The problem is that when you wrote the...
  • .NET4Office

    DevX Microsoft Office Professional Developer Portal

    • 0 Comments
    DevX just launched the Microsoft Office Professional Developer Portal on DevX.com ( http://www.devx.com/officeprodev ). This is a great new resource for developers using Office to build solutions. Check it out!
  • .NET4Office

    Setting a Range of Cells in One Call

    • 3 Comments
    A reader writes: I've enjoyed reading your online blog about Excel/Dotnet integration. I have a question, that if anyone would know the answer to, hopefully you do. Is there any trick that can be used to speed up insertion of large blocks of data into...
  • .NET4Office

    VSTO Security Model Principles

    • 0 Comments
    VSTO takes a very strong stance on security to prevent the spread of macro viruses or worms. VSTO's security model involves the trust of two things: 1) the assembly associated with the document must be trusted and 2) the location the document is coming...
  • .NET4Office

    Want to work on VSTO technologies?

    • 2 Comments
    Visual Studio Tools for Office is really taking off and the team that creates VSTO is growing fast. If you are interested in working at Microsoft and helping us build tools to help developers build customizations for Office, please check out this list...
  • .NET4Office

    My Add-in Project Doesn't Work Anymore--What Happened?

    • 2 Comments
    A common issue that occurs in add-in development goes like this. “I just pressed F5 on my add-in project and nothing happens! My add-in doesn’t appear to load. What’s the deal”? Office has a system to protect itself from Add-ins gone wild. Once you understand...
  • .NET4Office

    Awesome Videos Illustrating VSTO's Data Binding Features

    • 3 Comments
    Kathleen has just posted two new videos showing how VSTO's Data Binding Features work. I guarantee you'll be wowed by these videos. The first shows the creation of a databound list and controls in Excel created by simply dragging and dropping. The second...
  • .NET4Office

    Some new VSTO resources

    • 0 Comments
    If you haven't checked it out yet, Chris Kunicki has created a VSTO Zone at his site that has a bunch of useful information about VSTO: http://www.officezealot.com/vsto/ Also, Kathleen has posted some more VSTO video tutorials: Demo 5--How to Resize Excel...
  • .NET4Office

    Working with Word Collections and using get_Item

    • 0 Comments
    Items in a Word collection are accessed in two different ways depending on whether the index into the collection is strongly typed or weakly typed. In the case of the KeyBindings collection for example, the index is strongly typed as an integer. As such...
  • .NET4Office

    Writing user defined functions for Excel in .NET

    • 16 Comments
    I've updated this article with some new guidance-- for the details, see this post . Excel enables the creation of user defined functions that can be used in Excel formulas. A developer must create a special kind of DLL called an XLL. Excel also allows...
  • .NET4Office

    When foreach in Excel goes wrong

    • 3 Comments
    This seems like a reasonable piece of code: For Each oCell As Excel.Range In Me.Range("a1:b5") oCell.Value = "test" Next so does this: foreach Excel.CustomProperty prop in worksheet.CustomProperties { Console.WriteLine(prop.Name); } Unfortunately, when...
  • .NET4Office

    More VSTO 2005 Video Magic

    • 1 Comments
    Kathleen has created two new videos you should check out. Nice! Demo 5--How to Resize Excel Controls D e mo 6 - How to Add Controls to the Actions Pane
  • .NET4Office

    Office Watsoning and Exceptions in VSTO 2005 Beta 1

    • 0 Comments
    [EDITOR'S NOTE] Blogging has been slow as we are spending almost all our time getting Beta 2 out the door. You may have had the experience of Excel or Word causing an Office Watson error at debug time when you have an exception that occurs in your Windows...
  • .NET4Office

    Another officewiki.org plug.

    • 1 Comments
    I've been doing some C# development with the Excel object model and when you look at Excel objects in the object browser or in intellisense there are two major problems you run into: 1) Methods that would be hidden in VBA are shown in the object browser...
Page 6 of 9 (214 items) «45678»