Information

The information in this article applies to:

• Microsoft Excel 2000 and later.
• Microsoft Windows 2000 and later.
• .NET Framework 2.0 and later.

Release notes:

• 28-12-2007:
  A blogpost about the Excel 2003 & Windows Vista bug is now available.
• 11-12-2007:
  Eliminated an error message when Excel is automated from another software or command line.
• 09-12-2007:
  Important: The present version does not support Excel 2003 with Windows Vista.
• 08-12-2007:
  A minor but an important update of the help file.
• 04-12-2007:
  .NET Co Library released.

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:

• Requirements
• Known issues
• Installation

The help file can be downloaded as a separate file (see below - NET Co Library.chm) 

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 inputs to improve it.

Acknowledgement

Special thanks are due to the following people, who volunteered  their time as beta testers for .NET Co Library:

• Ken Puls (ExcelGuru) - An extra thanks for all valuable input during the developing process.
• Ross Mclean (Methods in Excel)
• The Group (You know who you are)

Screenshots
The following screenshots shows some of the main Windows Forms that are in use:

# Connections' Library

# Code Library:

# Insert Code:

# Move the database or change the path to it: