Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

November 2007 - XL-Dennis's Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Build Office-Based Solutions Using WPF, WCF, And LINQ

    Andrew Whitechapel has written an article in the December 2007 number of MSDN Magazine (Build Office-Based Solutions Using WPF, WCF, And LINQ) The article is interesting in many ways: The case in the article use Visual Studio 2008 and .NET Framework 3.5, i e the latest version of the .NET platform. It shows how to implement the latest new technologies (WPF, WCF [...] Read More...
    Filed under:

  • Access running instances of Excel in VB

    When automating Excel from VB we can either create new instances or access already running instances. In different scenarios different methods may be needed in order to get workable solutions. In the first scenario we may need to access a running instance and if not we need to create a new one as the following sample shows: This is a rather simple method [...] Read More...
    Filed under:

  • Open Excel workbooks in VB.NET Solutions

    In some forums I frequent (more precisely lurking around) the question “How can we open Excel workbooks in .NET solutions?” is raised from time to time. Usually it does not refer to how to read data from closed Excel workbooks rather how to open and work with workbooks in VB.NET and in a similar manner as we can do in Excel. The possible [...] Read More...

  • Office Open XML - OOXML

    One of the items on my To-do list is to learn more about RegExpression. Another item is Office Open XML (OOXML). Whenever I decide to teach me more about a specific topic I usually start to “google” to locate relevant online resources. If the subject is very interesting I also try to locate books on the subject as I [...] Read More...

  • .NET Co Library - Part V

    To read previously posts about the .NET Co Library please see the following entries: Part I Part II Part III Part IV Based on input from some testers I decided to implement a dedicated Windows form to only insert code into modules with. However, all other ideas and suggestions may only be considered to be implemented in future updates of .NET Co Library. Insert code In one [...] Read More...
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.