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

Browse by Tags

  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • UAC Compliant

    UAC stands for User Account Control and is the new technology in Windows Vista to provide users with different level of administrative rights and privileges. UAC main purpose is to support a more secured environment then what Windows XP offers. Microsoft has a good white paper that covers UAC in detail and therefore I have no intention to cover it [...] 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.