Here is the BETA version of my Colour Manager, and tool for creating colour pallets in Excel:
It’s a VB6 com addin, the only thing you really need to know is that you load a picture on the left and then click that picture to get the colour at that point. You can then click a pallet square to place it where that square is. Click the send to workbook button to send it to the active workbook.
However I have also made a video to show how to use it. Bosh!
Sam asked if you could build custom task panes with VB.Net Express edition. The simple answer is no. However this question raises a deeper issue.
What are all the options when it comes to extending Excel (or any other office app for that matter). Most of us know about XLA, XLL, DLL, etc but the .Nety stuff is not as well understood. In an attempt to shed some light on all of the options I have tried to make a simple table weighing up the options I’ve also bugged VB6 and Delphi in at the end just to help compare the options.
I should point out that I haven’t even used some of these technologies myself, so I’m not suggesting this is the definitive answer, but I think it’s a fair reflection, and I can tell you that I’ve not be able to find anything else like this on the net, so this is a World Exclusive!!!
Heres the PDF wall chart!!!!
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…
Bob’s Bloging!
8 August 2009 by Ross McLean
Good news all round:
Bobs Bloging – missed that one J-walk, :-)
Tags: Blogs, Comment
Categories: Addins, General • 5 Comments »