Monthly Archives: Nov 2011

Dictionary VBA Class update

Posted on Nov 24, 2011 by Patrick O'Beirne, Excel/VBA developer

I’ve uploaded a new version of the Dictionary Class and a helper KeyValuePair Class. This exposes the KeyValuePairs collection so iteration is now very fast, about 2 seconds to iterate 1 million items using a for each loop:   dim oKeyValuePair … Continue reading →

Posted in Excel/VBA | Tagged , , , , | 53 Comments

The Science of Spreadsheet Risk Management, July 5-6 2012, Manchester UK

Posted on Nov 23, 2011 by Patrick O'Beirne, Excel/VBA developer

The European Spreadsheet Risks Interest Group (www.eusprig.org) has issued a call for papers for their 13th Annual Conference on the theme “The Science of Spreadsheet Risk Management”. The conference will be held on the 5th and 6th of July 2012 … Continue reading →

Posted in Excel/VBA, Risk | Tagged , , , , , , , , | Leave a comment

SoftTest Event With Geoff Thompson and Graham Thomas in Galway, Dublin and Belfast

Posted on Nov 15, 2011 by Patrick O'Beirne, Excel/VBA developer

SoftTest Ireland (www.softtest.ie) in association with its sponsors (InterTrade Ireland, Sogeti and Software Skillnet) would like to announce the following events in Belfast, Galway and Dublin featuring two international speakers Geoff Thompson and Graham Thomas. Full details at http://softtest.ie/sign-up-for-our-next-event-with-geoff-thompson-and-graham-thomas/ “Testing, … Continue reading →

Posted in Software Quality | Tagged , , , , | Leave a comment

Software Development Productivity Analytics?

Posted on Nov 14, 2011 by Patrick O'Beirne, Excel/VBA developer

Does anyone know of current methods to record developer time with some kind of analysis either post hoc review or concurrent notetaking to show where time is being spent? In the Personal Software Process (PSP) the first stage is to … Continue reading →

Posted in Software Quality | Tagged , , , , , | Leave a comment

Spreadsheet Guru Contest, CA, April 15th 2012

Posted on Nov 14, 2011 by Patrick O'Beirne, Excel/VBA developer

From the INFORMS Spreadsheet Productivity Interest Group (SPRIG) “Speaking of conferences, we’re extremely excited to announce that the First Annual SPRIG World Spreadsheet Guru Contest will be held at the 2012 Analytics Conference in Huntington Beach, CA on Sunday, April … Continue reading →

Posted in Excel/VBA | Tagged , , , , , , , , | Leave a comment

Free Excel formula highlighting tool

Posted on Nov 4, 2011 by Patrick O'Beirne, Excel/VBA developer

My main product is the XLTest addin that does a comprehensive shakedown of Excel workbooks. I’ve picked out the most popular feature, colour coding cells by formula region, and give it away as a free taster, the XLTest Colorizer. It … Continue reading →

Posted in Excel/VBA, Risk | Tagged , , , , , , , , , , , , , | Leave a comment

Excel developer conference London Jan-2012

Posted on Nov 4, 2011 by Patrick O'Beirne, Excel/VBA developer

Agenda is being formed by leading European Excel dev Simon Murphy, proposals still being welcomed: http://smurfonspreadsheets.wordpress.com/2011/11/03/excel-developer-conference-london-jan-2012/

Posted in Excel/VBA | Tagged , , | Leave a comment

Dictionary Class in VBA instead of Scripting.Dictionary

Posted on Nov 2, 2011 by Patrick O'Beirne, Excel/VBA developer

In adapting an addin for Mac Excel 2011, I found that the Mac did not have the reference to the “Microsoft Scripting Runtime” dictionary (scrrun.dll). So, I wrote my own using a Collection. You can download it here: Dictionary.cls (update: see … Continue reading →

Posted in Excel/VBA | 80 Comments