Programming

  • 14-Sep-2020 : Ghost break?
    Your code compiles perfectly and has worked thousand of times before, but suddenly it starts giving you a nasty error message: ‘Code execution has been interrupted’. It looks like the one you get when you press Ctrl-Break or when your code produces an error which you haven’t trapped, but it isn’t either of those ...
  • 12-Sep-2020 : Web page logging
    This is the oldest bit of PHP in my possession, based on something I found on the Web about ten years ago but tweaked by me over the years to suit my purposes.  It logs all accesses to a Web page …
  • 11-Sep-2020 : Online PHP editor
    As a fairly inexperienced PHP programmer, I tend to make quite a few mistakes.  Not huge, catastrophic mistakes, just tiny little ones, ones which produce the wrong results or even stop the code running but which won’t bring a Web site down.  Usually.  But just now and again I do something which breaks one of ...
  • 26-Aug-2020 : MS Office Automation
    This is a list of the sorts of things that can be done using VBA as far as Office 2016 is concerned. I’m now on Office 365, so there may be slight differences in coding techniques for some of these things: I’ll update this note as I find them. This is certainly not an exhaustive ...
  • 05-Dec-2012 : Accessing the Visual Basic Environment (Excel)
    Save your workbook before you proceed any further. If you’re using Excel 2007, you’ll need to make sure it’s saved as a macro-enabled workbook (*.xlsm). Keep this copy as a backup: VBA code can be extremely destructive and there’s no Undo facility to fall back on! Select Developer > Visual Basic from the Excel ...