Hi Coal, welcome to the Forum !
I remember Chandoo has an article about this, the article also mentioned since the Twitter has changed the settings. It is not possible now.
@Lymm
Hi!
It isn't bad at all, the problem is that even the data is stored in an Excel workbook, the twitter can't be generated from Excel since the platform owner decides to shut that door, forcing everybody to find other non-native Excel software to do the job.
For example rssbus (http://www.rssbus.com/) which appears to work but I can't confirm it.
Regards!