Richard, you explained in an earlier reply how I could get Google to show me the correct format for a URL to show the map of a certain zipcode.  But what is the way to invoke such a map from a command button?  Is it a SHELL command to IE?  I tried using the hyperlink property, but I don't see a way to insert the correct zipcode on the fly.  I want to have the user double click a zipcode and have a map of that zipcode pop up in IE.

---

Reply from Richard Rost:

Yep. SHELL will work fine.

URL = "http://www.599cd.com"
Shell """c:\program files\internet explorer\iexplore""" & URL, vbNormalFocus

The extra double-quotes are because of the spaces in the path the IE executable.

Now if you want to be real cool, you could also drop a WebBrowser control in your own form and use that instead of launching an external copy of IE. I cover that in my Web Synch seminar.