Would like to say thank you for all the email / forum responses in regards to my last post. Although I may of come across as hopelessly stalemated, I have had some correspondence with a few really helpful guys. It's to be expected really, needing to sift through a number of time wasters before meeting someone useful. Do not think it's particularly appropriate to mention all names but you all know who you are, so thank you once again to all who have offered support.
It seems the consensus in regards to my botting needs is to learn how to program the bot myself rather than rely on anyone else. Problem with this route is it will takes much longer before seeing any results, but in regards to the longterm it gives me many more options and the flexibility to adapt. Having spoken to a couple of guys on the forums VBA doesn't seem all that daunting, although ultimately C# appears to be the language to pursue. I suppose if and when I feel I am being limited by Excel & VBA that would be the time to look at switching to C#. As a start though I'm looking at the Excel integration route. One plus with this route is being able to use the vendor API subscription, as I can see the limitations with the free API restricting the possibilities somewhat.
Also think I am developing a serious case of roboguilt, that is for every waking moment I'm not otherwise occupied, I should be working on this damn bot! Any cures for roboguilt, you know the email address!