Custom Office Programming and Automation
Bing has an API for, among other things, translating text from one language to another.
Many of you are familiar with the approach found at Translating text, or perhaps your searching has brought you to Google translate by Internet Explorer Automation, a hellacious-to-read example. Here's my entry.
Continue Reading: Translation services using Bing API »
If you live in Australia, you'll need to know the post code for your letters, bills and postcards. Here's some VBA code and a sample app that can help you look up post codes in Australia.
Continue Reading: Looking up Australian postal codes »
Hot on the heels of my update to the Latitude/Longitude functions page, I've written some more VBA code that uses web APIs to retrieve weather information for any zip code in the U.S.A. If you visit that page and then look at the code below, you may notice the similarity.
Continue Reading: Got weather? »
Did you ever want to check currency exchange rates but thought it was too difficult? Here's one method of doing so using web services.
The Currency Convertor from WebserviceX.NET lets you look up exchange rates for 151 different currency types. All you need to do is formulate the URLs to request the two currencies and the web service returns the exchange rate. Let's take a look at just how to do that.
Continue Reading: Get currency conversion rates with web services »
A recent visitor to the site sent me some code that generates tiny urls programmatically. It uses the Internetexplorer.Application object to automatically insert text in the appropriate text boxes on tinyurl.com and submit the form to generate a shortened URL.
Continue Reading: Create Tiny URLs using VBA »
Follow Me