-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
To read previously posts about the .NET Co Library please see the following entries: Part I
Part II
Part III Here in this post focus is set to deployment and known issues.
Deployment
Requirements
Using one of the following Microsoft Windows versions: Windows 2000 SP-4 and later
Windows XP SP-2 and later...