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

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • AddInSpy - The missing diagnostic tool!

    I thought that I should flag for the new diagnostic tool, AddInSpy, from MSFT. I have only started out to test it but I already like what I see. It can be a valuable source to detect present status for individual COM add-ins of all kind, i.e. managed, VSTO and unmanaged and provide a great number of...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Wed, Oct 1 2008
  • Everyone or Just Me?

    When we install new software we usually are given the options to either install it to “Everyone” or “Just Me”. Under normal conditions this is not an issue but suppose that we only want to install the software to either the person (”Just Me”) who installs it or to...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Sun, Sep 28 2008
  • Learning LINQ

    At present my time table does not permit me to explore new things so I have postponed delving into some areas to the next year. However, in some cases I have made some research to get access to interesting sources and tools which I hope will help me out. LINQ is one area that is of high interest which...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Sun, Sep 28 2008
  • 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...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Wed, Aug 27 2008
  • 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...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Sat, Jul 26 2008
  • 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...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Wed, Jun 25 2008
  • 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...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Sun, Apr 27 2008
  • 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...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Sun, Apr 13 2008
  • 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...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Tue, Feb 12 2008
  • 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...
    Posted to XL-Dennis's Blog (Weblog) by Anonymous on Mon, Jan 28 2008
Page 1 of 2 (19 items) 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.