Has anyone managed to figure out how to access Twitter from VBA since basic auth was shut down?
On Aug 31, 3:31 am, Timo <elliott.t...@gmail.com> wrote: > Hi, > > I have an application that posts tweets automatically from PowerPoint > each time a presenter gets to a particular slide: > > It's a relatively simpleVBAscript that uses basic authentication > (until tomorrow, when it gets turned off!) . Because it's a full- > client application, I requested, and obtained, the ability to use > xAuth. > > But I've struggled to find an easy way to use xAuth / Oauth fromVBA. > I'm not even sure it's possible at all using onlyVBA-- specifically, > I haven't found any "nativeVBA" HMAC-SHA1 code, and lack the skills > to write one (I found this post on SHA1 inVBA, but don't know how to > include the key / HMAC part -- anybody > know?:http://splinter.com.au/blog/?p=86). > > As a workaround, I tried adding a DLL to do the HMAC-SHA1 part, based > on this > post:http://blog.gobansaor.com/2008/02/22/xlaws-excel-vba-code-for-accessi..., > and haven't completely given up, but my attempts so far don't seem to > generate the right signature (i.e. when I cut and paste the available > xAuth demo code from twitter, I get a different result than they do). > I also started checking out the HMAC-SHA1 library > fromhttp://www.cryptosys.net/#api, > but my application is freeware, so trying to avoid commercial code... > > And I know there are .Net VB libraries like > TwitterVBhttp://twittervb.codeplex.com/, > but I don't know how to access those methods/properties fromVBA-- is > it possible? Could somebody point me to demo code that shows how to > use something like that fromVBA? > > Many, many thanks in advance to anybody who can help my application > from dying tomorrow!... -- 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