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

XL-Dennis's Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • COM Shim Wizard Version 2.3.1 is released

    The version of the COM Shim Wizard that supports VS 2008 is finally available. The documentation seems to be the same as for the previously version, indicating that the update is only to make sure it works with VS 2008. In other words, it works with both VS 2005 and VS 2008. To download it You can use [...] Read More...
    Filed under:

  • VS 2008, COM Add-ins and launch conditions

    I can create COM add-ins based on the Shared Add-in template in VS 2008 and they all work well on my developing computer. However, I got an issue when I tried to deploy them on configurations where only .NET Framework 2.0 is installed. In the New Project dialog we can select the targeting .NET Framework version, 2.0 [...] Read More...
    Filed under:

  • VS 2008, Excel 2003 on Windows XP

    Recently I faced a situation where I created a managed COM add-in, based on the Shared Add-in template in VS 2008, which didn’t work at all. The configuration I work with is: Windows XP with SP-3 Office 2003 with SP-3 VS 2008 I had no issue to create the managed COM add-in but when I debugged it didn’t work as expected. All [...] Read More...

  • Some links to useful sources

    A new and time consuming project keeps me busy so at present I don’t have the time to post here on a regular basis. Anyway, the following links points to several recently published articles by MSFT. Finally, the version 1.0 of Open XML Format SDK is released. It provides us with new tools to interact with the XML [...] Read More...

  • Check which Excel version is installed

    Whenever I need some enviroment information I always tries to read the wanted values from Windows registry. In VB.NET this is as rather straightful process as we have access to the namespace “Microsoft.Win32′ which includes the class to work with the registry. Recently I had a need to find out if Excel is installed and if [...] Read More...
    Filed under:

  • VB Snippet Editor

    Together with a lot of Intellisense improvements a large number of Code Snippets is also shipped with VB 2008. But what may be surprising is that there is no tool included to create and manage our own Code Snippets with. This is where VB Snippet Editor comes in. It gives us the option to develop our own snippets [...] Read More...

  • VSTO Power Tools

    Andrew Whitechapel announced yesterday that a new toolkit for VSTO and VSTA now is available for download. I will test most of the tools and review some of them here. For me these kinds of tools are very important as they can both save time during the development cycle and when troubleshooting targeting computers. What should be noted is the following: The toolkit [...] Read More...
    Filed under:

  • Export data from DataGridView to Excel

    A common task is to view filtered data from databases in Windows applications where the users then can select records to be imported into Excel. In this context the main issue is usually how to achieve an acceptable performance when writing the selected data to Excel. When it comes to automation of Excel the communication between Excel and for [...] Read More...

  • Measure Data Quality

    Nowadays it’s a common task to retrieve data from databases and put the data into MS Excel. The acquired data is usually part of the information in decision processes. The data that is stored in databases are either collected automatically or manually. The process of collecting data manually can either be dictating or free. With ‘dictating’ I mean [...] Read More...

  • RibbonX: Customizing the Office 2007 Ribbon - Review

    Title: RibbonX: Customizing the Office 2007 Ribbon Authors: Robert Martin, Ken Puls, Teresa Henning (Oliver Stohr) Publisher: Wiley Year: 2007 Target group: According to me: Power user to professional VBA-developers Targeting softwares in the Office suite: Excel 2007, Word 2007 and Access 2007 Ranking: 7.5 (out of 10) Comments This book is the first of its kind as it explicit only target the RibbonX and how to manipulate and customize it. It covers how to [...] Read More...
    Filed under: ,

  • Excel User Group

    Nick Hodge has recently set up a new peer-to-peer forum with Blogs, Forums and File areas for Excel users. For more information and member registration please see: Excel User Group What makes it attractive is that it has an Add-ins subforum: VSTO/COM/XLL Add-Ins This subforum will discuss and also be a Q&A forum for: COM Add-ins created with VSTO (and also about workbook level [...] Read More...

  • Excel 2003 & Windows Vista bug?

    Introduction After the release of .NET Co Library I immediately received some inputs indicating that the add-in does not work with Excel 2003 on Windows Vista. For some unknown reasons, at least for me, this configuration was not tested before I released the add-in. (It was tested on Windows Vista where Office 2003 and Office 2007 coexisted but not Office 2003 alone on Windows [...] Read More...

  • .NET Co Library is released!

    Introduction I have finished the work with .NET Co Library so now it’s officially released. It has been an interesting project in many ways. To work with the VBE’s object model has been a challenge and I’m looking forward to the day when it has been replaced. I hope that this tool can be a valuable tool in the [...] Read More...
    Filed under: ,

  • 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:
1 2 Next >
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.