I don't see where the space is missing.. I did not put quotes in the base string. I assume that it only serves as a way to claculate an oauth signature, which is calculated exactly as by your website and by twitter.
Still stuck.... On Sep 21, 12:16 am, Tom van der Woerdt <i...@tvdw.eu> wrote: > Multiple things: > * You missed a space in the Authorization header. Go look in my post ;) > * You don't have to put the quotes in the Base String. Only in the > Authorization: header. > > Tom > > On 9/21/10 12:14 AM, Randomness wrote: > > > > > I still get the same mistake all the time, after I get asked and > > cancel for a username and password: > > > <?xml version="1.0" encoding="UTF-8"?> > > <errors> > > <error code="32">Could not authenticate you</error> </errors> > > > The xml part of the VBA now looks like this: > > > Set xml = CreateObject("MSXML2.XMLHTTP") xml.Open "POST", Cells(18, > > 3), False xml.setRequestHeader "Authorization", "OAuth" & Cells(17, 3) > > xml.Send tResult = xml.responsetext Cells(7, 5) = tResult Debug.Print > > tResult Set xml = Nothing > > > Cells(18,3) =http://api.twitter.com/1/statuses/update.xml?status=testing > > I believe calling it this way does not need quotes, because it is > > already called as a string. > > > I changed the authorization header. > > > I put quotes around the values and url encoded the values. Cells(17,3) > > now looks like this: > > > oauth_consumer_key%3D%22MYCONSUMERKEY%22%2Coauth_token%3D%MYOAUTHTOKEN > > %22%2Coauth_signature_method %3D%22HMAC-SHA1%22%2Coauth_signature%3D > > %22AXBM9Mpc2k3+/jYGTvs/JE4G8BQ=%22%2Coauth_timestamp%3D > > %221285025757%22%2Coauth_nonce%3D > > %22slnbcv0vxt1gzwfDz2Celv2ojcpqabyxoEB9sEal4%22%2Coauth_version%3D > > %221.0%22 > > > When calculating signatures I get the exact same values as are > > calculated on your Quonos site. They are also the same as calculated > > with the examples given by Twitter. > > > This is a tough nut to crack! :-) > > > On Sep 20, 9:06 pm, Tom van der Woerdt <i...@tvdw.eu> wrote: > >> Hi, > > >> I see multiple things that are wrong: > >> * You didn't put quotes around your URL > >> * You shouldn't send OAuth: as an header. The header is Authorization: > >> OAuth <headerstring>. (xml.setRequestHeader "Authorization", "OAuth " & > >> headerstring > >> * You should put quotes around the values in headerstring, and if you > >> haven't done so already, URLencode the values > >> * There's no signature in headerstring > > >> If you changed those, and it still doesn't work, please give these : > >> * A sample Base String > >> * A TCP dump of a full request, including response. > > >> Tom > > >> PS: Do I know you? > > >> On 9/20/10 8:38 PM, Randomness wrote: > > >>> 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.- Hide quoted text > >>> - > > >> - Show quoted text -- Hide quoted text - > > - Show quoted text - -- 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