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 daily work for developing VBA solutions in Excel. To my knowledge it’s a unique tool in that it does not exist any similar add-in.
I would like to thank Ken (Puls) and Ross (Mclean) for their help to test it and also for their contributions to improve the UI. I’m part of a mixed developer group which is named the “Group”. The “Group” major contribution was simple to raise the question “Why”.
The following is a summary about .NET Co Library:
.NET Co Library can be used with
- Microsoft Excel 2000 and later
- Microsoft Windows 2000 and later
- .NET Framework 2.0 and later.
What .NET Co Library is
.NET Co Library is a free managed COM add-in for Microsoft Excel. The acronym Co in its name refers to both Connection and Code.
With the tool you can:
Store created VBA code, code snippets / procedures / modules, and SQL Queries in a well organized way enabling you to easily reuse the code in all kind of Excel VBA solutions.
Create connection strings to a various number of databases with two wizards, the .NET Wizard and the Data Link Wizard. Store the created connections strings in a structural way enabling you to easily reuse the connection strings in all kind of Excel VBA solutions.
.NET Co Library has been designed so it also can be shared within a group of VBA developers over a network.
Requirements, known issues and installation
Before installing .NET Co Library it is important that you explicit read the following sections in the help file:
The help file can be downloaded as a separate file (see below).
The NET Co Library.zip file contains two files, the setup.exe file and the NET Co Library.msi file. Installing .NET Co Library on any Windows Vista version should be done with the setup.exe file.
The tool is available “as is” but XL-Dennis providing a free support for .NET Co Library and welcome any input to improve it.
To download the help file and installation package please see: Download XL-Dennis Tools
Note: There exist some improvements in the final version compared what I have been blogposting about so therefore please read the help file.