I believe I have solved all the issues of getting the right
information to send a tweet using Excel. Calculation of oauth_nonce
and oauth_timestamp look good and also the calculation of the
oath_signature seems to be in order.
When I try to post the message I get a message asking for user name
and password and when I cancel this I get an error 32.
I am doing the following:
Set xml = CreateObject("MSXML2.XMLHTTP")
xml.Open "POST", http://api.twitter.com/1/statuses/update.xml?status=text
of the update, False
xml.setRequestHeader "OAuth", headerstring
xml.Send
tResult = xml.responsetext
Debug.Print tResult
Set xml = Nothing
headerstring="oauth_consumer_key=myconsumerkey,
oauth_token=mytoken,
oauth_signature_method =HMAC-SHA1,
oauth_signature=calculatedsignature,
oauth_timestamp=1285014608,
oauth_nonce=81A1iuux8jzxgieaxmmp3ta2bDdqefd88hp9soo31,
oauth_version=1.0"
Any help wouldbe appreciated because I am really stuck.
--
Twitter developer documentation and resources: http://dev.twitter.com/doc
API updates via Twitter: http://twitter.com/twitterapi
Issues/Enhancements Tracker: http://code.google.com/p/twitter-api/issues/list
Change your membership to this group:
http://groups.google.com/group/twitter-development-talk?hl=en
