Unfortunately, and as predicted last year, Bainsworld Superannuation Fund had a negative return of -17.3% for 2008. Whilst not unexpected and probably reasonable given the carnage on the share mar...

If you ever need to determine if a file is already open before you attempt to do something with it in VBA, you will discover a bewildering array of code segments on the interweb which all seem to s...

In typical fashion I have neglected to post information to this blog until way after the event. In that vein, Bainsworld Superannuation Fund produced an investment earnings rate for 2007 of 42.7%,...

This is a simple digit only password generator that I use for a number of purposes. My recent post about managing automation objects uses this function and I forgot to include it there - I have upd...

I needed a way to manage calls to different office automation servers in a consistent fashion. These were mostly from Access to extract data from a large number of Excel workbooks. Specifically wha...

I realised that one of my earlier posts Generic Function to Copy Excel Data references a function called ‘tcStripChars’ in order to remove control characters from a cell value. This was required to...

I use Google Apps to host my family’s and my private company’s email but I manage my email through Outlook (because I prefer to operate off-line and I need to synchronise with my Nokia N95 phone). ...