Using MS Access 2000 VBA to send a Direct Message via the Twitter API

Question

I am trying to send a direct message via the Twitter API from Access 2000 VBA. I can post a status update to my Twitter account with the following code:

tUsername = "TwitterUser" tPassword = "theirpassword" tStatus = "some sample text"

xml.Open "POST", "http://" & tUsername & ":" & tPassword & "@twitter.com/statuses/update.xml?status=" & tStatus, False

This works fine, but when I try to follow the DM syntax, I get an "invalid request" -- something about the syntax where I have to specify the "-d" and the username I am not getting

The API help page from Twitter is here: http://apiwiki.twitter.com/Twitter-REST-API-Method%3A-direct%5Fmessages%C2%A0new

Thanks!

Answer 1

After clicking the "cURL" link, it seems there's more to it than just putting in the '-d' parameter.