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