I can’t find documentation for XML. I basically need a VBA code to make POST requires for tweet sending. So I would like to know how to authorize with XML - where to use all tokens and secrets? Thanks.
Twitter’s API doesn’t accept XML as an input format – only URL-based query parameters and URL-encoded POST bodies. We do support XML as an output format.
OAuth is a bit complicated of a process to negotiate in VBA, but this article written by another developer may help you out a bit: http://www.twopblog.com/2010/09/using-excel-as-twitter-client-with.html