(Excel) Twitter OAuth -- Tweet to Your Own Account

Demonstrates how to send a tweet (status update) to your own Twitter account using pre-known credentials, which includes:

1. Consumer Key
2. Consumer Secret
3. Access Token
4. Token Secret

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

http.OAuth1 = True
http.OAuthVerifier = ""
http.OAuthConsumerKey = "my-consumer-key"
http.OAuthConsumerSecret = "my-consumer-secret"
http.OAuthToken = "my-access-token"
http.OAuthTokenSecret = "my-token-secret"

' Send the same status update as shown in this example:
' https://dev.twitter.com/docs/api/1.1/post/statuses/update

' IMPORTANT: Make sure this app has read/write access.  
' Otherwise it cannot post an update (i.e. tweet) to the Twitter account.

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.AddParam "status","Maybe he'll finally find his keys. #peterfalk"

Set resp = http.PostUrlEncoded("https://api.twitter.com/1.1/statuses/update.json",req)

If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

If (resp.StatusCode = 200) Then
    ' Display the JSON response.
    Debug.Print resp.BodyStr
Else
    Debug.Print http.LastErrorText
End If