Monthly Archives: May 2012

Conditional Format recalc oddity

This came up on the Excel-L list recently – maybe some reader can explain it. The requirement was to base a Conditional Format on a user-defined expression entered as text. The easy answer is for them to enter it as a … Continue reading

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

Corporate Governance and Safe Spreadsheet Practice

I am giving a presentation at the Institute of Chartered Accountants Ireland in Dublin on 5th June at their event “Corporate Governance and Safe Spreadsheet Practice – The Importance of Mitigating Risk for Professionals” which also features Dr Kevin McDaid of … Continue reading

Posted in Research, Risk | Tagged , , , , , , , , , | Leave a comment

Spreadsheet Structure user study call for participation

This was posted today by Felienne Hermans in TU Delft to the Eusprig yahoogroup For hopefully 🙂 the final chapter in my PhD thesis, I am running a spreadsheet user study, see I would like to ask you all … Continue reading

Posted in Excel/VBA, Research, Software Quality | Tagged , , | Leave a comment

Migrating Excel VBA Add-in to VB.Net, ExcelDNA, NetOffice

I have updated my previous post on migrating an addin with this 15-page Word document listing some of the things that kept me editing and debugging for two weeks on a 13,000  VBA LOC addin. I hope some of these … Continue reading

Posted in Excel/VBA, ExcelDna | Tagged , , | 6 Comments