Browse by Tags

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 values. The [...] Read More...

Published Wed, Oct 10 2008 1:59 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins, Tools

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 everyone who will be using the computer? In the first case, i.e. “Just Me”, it’s [...] Read More...

Published Sun, Sep 09 2008 6:28 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins, Tools

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 may replace SQL within [...] Read More...

Published Sun, Sep 09 2008 6:27 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins, Tools, SQL Server 2000/2005

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...

Published Wed, Jun 06 2008 1:41 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins, Tools, SQL Server 2000/2005

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...

Published Sun, Apr 04 2008 7:57 AM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, Tools

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...

Published Mon, Jan 01 2008 2:33 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins

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...

Published Thu, Jan 01 2008 6:14 AM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel

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...

Published Wed, Dec 12 2007 2:56 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins

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...

Published Fri, Nov 11 2007 4:50 AM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel

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...

Published Sat, Oct 10 2007 10:59 AM by VSTO & .NET & Excel

Filed under: .NET & Excel, VSTO & Excel, COM Add-ins

Syndication

Recent Posts

Tags

Archives

AddInSpy - The missing diagnostic tool!

Everyone or Just Me?

Learning LINQ

Some links to useful sources

VB Snippet Editor

Measure Data Quality

Excel User Group

Excel 2003 & Windows Vista bug?

Office Open XML - OOXML

UAC Compliant