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
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
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 http://swerl.tudelft.nl/bin/view/FelienneHermans/SpreadsheetStructureStudy I would like to ask you all … Continue reading
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
Patrick O'Beirne @ sysmod 