Posts

  • 2008 Super Fund Performance

    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 market, it is nonetheless disappointing. However,...

  • Is that file open?

    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...

  • 2007 Super Fund Performance

    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%, a huge improvement...

  • Simple password generator

    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...

  • Automation Manager Class

    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 what I wanted...

  • Strip different types of characters from a string

    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 prevent Excel...

  • Automatic email account assignment in Outlook

    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...

subscribe via RSS