Office links for April


It's been quite a month, with a lot of activity on other sites as well as this one. Let's get started!

API overload

My API usage hasn't gone unnoticed — using the New York State Legislature API from the New York Times got me a mention in one of the NY Times Blogs: Roll-Call Votes and Roulette: Times APIs.

The next NY Times API I'll be using is the Congress API. Maybe I'll make the roll call.

Over on the Wordnik Google group I've seen some people using my Wordnik API code samples. Check them out if you haven't already.

Who needs Outlook security?

Wayne Phillips at Everything Access has put out a product called vbMAPI which is designed to get around Outlook's security prompts. It is meant to be a competitor to Redemption, but Redemption does more than just avoid Outlook's security prompts. I haven't tested vbMAPI, if anyone has done so, I'd be glad to hear if it actually works.

MVP Roundup

Mike Alexander (the man with two first names) showed us how to remove user names from Excel comments. I could go either way on this. When creating a workbook for a client, however, I change my username to something other than my name. That way, you can create comments, then change the username back, and the existing comments won't revert. Try it!

Debra at Contextures Blog shows us that sometimes built-in features are the best ones to use. In Count Items in List with Excel Pivot Table uses a Pivot Table to group items and count them. Otherwise you'd need a bunch of formulas, and where do you put those?

Dick from DDoE shows us how to create dynamic names in VBA. He has a specific purpose for them (arrays). If you want to see how I do it, visit Add dynamic ranges names to any worksheet.

Twitter issues

Twitter developers beware! Their API authentication is becoming more sophisticated. Programmable Web reports that Twitter's REST API will require OAuth authentication starting in June of this year. That means the basic authentication we've been using will probably be deprecated and stop working shortly after that.

I think Twitter is taking itself too seriously. At the end of the day, it's just a silly messaging service. Do tweets really need this much protection?

As a result, these projects (as they exist currently) will probably stop working:

I'm planning on re-working them at some point, mostly to learn how to authenticate using OAuth rather than a burning desire to tweet from Microsoft Office. That's in addition to rewriting the delicious API code to use YQL.


On the Blogs I Read page, sites get shuffled around if they don't post in a while. If you saw your blog there and now it's gone, that's probably why. I still monitor your blog in the hopes that some new content will surface, but it won't appear unless you post more often. My suggestion is to post at least once a month. If you want to see your blog there, contact me, but note that I only list blogs I actually read.

About JP

I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space to learn more about VBA. Keep Reading »

Related Articles:

Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button

This article is closed to any future comments.
Excel School