After playing with Excel for some time now I am pretty much safe in saying that you can do just about anything with Excel. It isn't just for number crunching and creating graphs. To that end I thought about creating a TwitterBot using Excel just because I can. I've seen them in many other computing languages but not in VBA. However I did find this rather splendid post on just that. It all looks pretty complex and granted it is much more long winded than in some languages (I built something similar in Ruby not so long ago and that was quite 'slimline' in comparison) but it does the same thing and is pretty useful.
Having adapted the code so that it will pick up tweets from a sheet. It simply runs in the background tweeting at intervals of one hour from the point of starting. Once you finish the list, it'll start again.
It'll even check your tweet length to make sure you stick to 140 characters.
Content delivery without having to sit by the computer and do it manually and all in Excel. What could be simpler!
If you would like to have a go just click here and download the file.
It works in Excel 2007 and newer but is untested in previous versions.
All that needs to be done then is enable Macros on opening the file and follow the simple instructions contained on the first page about authorising the application with your Twitter account.
Once this is complete it doesn't need to be repeated.
Add Tweets using the add tweet function and hit start to start tweeting. The application will continue until you stop it or you turn off the power!
