March 2011 Archives - JP Software Technologies

UEFA Team Logos and Country Flags In Excel

March 28, 2011 by JP

Just in time for the Champions League quarterfinals, here's another frivolous spreadsheet that pulls images from UEFA.com into Excel.

Filed Under: Excel

Tagged With: URL, WebBrowser

ShipTrack 4.2 Now Available

March 25, 2011 by JP

22 Comment(s)

ShipTrack Update

ShipTrack 4.2 is now available, with support for TNT and YRC.

Visit those websites for a list of supported regional carriers.

Download ShipTrack

Filed Under: AddIns, Excel

Tagged With: addin, ShipTrack

Google Static Maps API in Excel

March 21, 2011 by JP

1 Comment(s)

The Google Static Maps API may be leveraged in Excel wherever you want local street maps of your area. Here I'll review some basic techniques for building links that let you display maps from Excel and VBA.

Continue Reading »

Filed Under: Excel

Tagged With: API, Excel, hyperlink, maps, static, VBA

Countries I won't ever be famous in

March 14, 2011 by JP

2 Comment(s)

My web stats show that visitors to this site have come from 215 countries. Which is amazing because the U.S. State Department recognizes only 194 official countries.

Here are the "countries" that haven't sent even one lousy hit.

Filed Under: VBA

Tagged With: countries, map

Get Word Count in VBA

March 7, 2011 by JP

3 Comment(s)

word count

In VBA Function To Calculate Number of Words in a String there's a function to count the number of words in a given string. I think it could use some tightening up.

Filed Under: VBA

Tagged With: count, LBound, split, ubound