Right that should get a few people here!
XL Dennis has made public the first version of his code librarian - “.NET Co Library”.
I’ve done a bit of testing for this addin and can personally vouch for how useful it is - keep all you VBA code in one place - copy the .mdb and take it with you, bung the .mdb on a network drive and you can share your code with the world (well the folks with access to the network any road)
Here’s what Dennis has to say:
.NET Co Library is a 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 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 connection strings in a structural way enabling you to reuse the connection strings in all kind of Excel VBA solutions.
.NET Co Library has been designed so it can be shared by a group of VBA developers over a network.
Thats right, it’s the future, it’s .Net!!!
The addin, makes it easy to save code snippets, (even whole modules) and search back through them in other projects - it’s a much better way to work with code than just copying it out of other workbooks…
But it’s not just VBA code, it’s SQL, and connection strings too…
What more could a Excel programmer ask for? Go on give it a try! And did i mention it was free…