Charles Williams is probably best known for his work in Excel calculation speed and VBA performance, not to mention the worlds most famous Excel Addin Name Manager. In truth, he’s a expert in many areas of Excel and on top of all this he’s a great bloke. In this podcast we got down and dirty with Excel performance, uncovering some interesting insights along the way. It was a true pleasure talking with Charles.
Charles the First - King of Speed!
Charles in the founder of Decisions Models, a consulting firm specialising in Excel development, and the farther of the FastExcel addin, we talked about this addin and how it works and also his addin loader tool. This is one for the archives!
Thanks to Charles for making the time and sharing his knowledge with us all.
Back in February I did a podcast with Mike Woodhouse, based around testing VBA code. Mike has written a unit testing frame work for VBA code, called xlUnit. Over the last few weeks I’ve been using xlUnit to help write a generic validation class for VBA, so I thought I would put together a little video of how the addin can be used to write tests for your code.
Its in 2 parts because you can only upload videos that are 10 minutes long to you tube. The first part is the basics and in the second part I show some examples from my project.
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!
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 »