Category Archives: Uncategorized

Modeless Userform not terminating

One way to display status messages as a long procedure runs is to show a modeless userform and update it with text or a progress bar showing percentage completed. I was having a problem with Excel crashing, particularly Excel 2013, … Continue reading

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

VBA Code Tracer / Profiler

A VBA module to insert code to trace the execution of VBA code. Continue reading

Posted in Excel/VBA, Software Testing, Uncategorized | Leave a comment

Excel Options for updating external links

There are many options in Excel that control this depending on the kind of link it is. I’ll cover the usual external links in formulas first, then finish up with the other kinds. An external link formula shows the full … Continue reading

Posted in Excel/VBA, Uncategorized | Tagged | 5 Comments

XLTest 1.55 released

I have updated my spreadsheet auditing addin. Changes in version 1.55 1.    On startup, it checks and fixes autonumber seed problems in database 2.    Processing limit of 1 million cells made an option 3.    ExportActiveProject procedure runnable by VBA automation … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Excel VBA Copy Range, Paste as Table to Powerpoint 2010/2013

So, I’ve spent the last couple of weeks trying to get that one right. Piecing together all the hints from stackoverflow and the rest, I find that I have to use the ExecuteMso method available in PP2010 and later, and use … Continue reading

Posted in Uncategorized | Tagged , , , , | 22 Comments

Dumb email bounces

A spammer is sending mail to Polish addresses faking an address from one of the domains I administer. Nothing unusual in that. What’s more annoying is all the recipient postmasters replying to the APPARENT from-address, ie my address, saying the … Continue reading

Posted in Uncategorized | Tagged , , , , , | Leave a comment

The Art of the Cell

I liked this post on the Excel-L list today. On 07/05/2014 10:21, Laurent Wright wrote: Reminds me of a question, many years ago, that I got asked. In Layman’s terms, what is the difference between Access and Excel? My reply … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Eusprig 2014 Delft – For Excel Builders and Inspectors

Thursday 3 July 2014, Delft, the Netherlands. And it’s FREE thanks to our sponsors! This is for the two sides of the house – those who use spreadsheets to solve their problems, and those who are concerned about the risks … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | 9 Comments

Dumb autoresponders

I went on holidays before Christmas and set up an email autoresponder to say I was out of the office. So I left and next day decided to use the free wifi to check the email. Not something one should … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Reinhart & Rogoff: The Austerity spreadsheet error

We’ve discussed this on the yahoogroup of the European Spreadsheet Risk Interest Group, of which I’m the current chair. Here’s my summary of The Spreadsheet Error Heard Round the World, with my commentary followed by the background. 1) The authors … Continue reading

Posted in Excel/VBA, Research, Risk, Software Testing, Uncategorized | Tagged , , , | Leave a comment