I'm completely new to VB editing and I finally got the basics of the web query working. However, when I try to make it dynamic by referencing a cell for the parameter, it say the web query returned no data.
I'm not sure what I'm doing wrong...it should be a very simple query, I only have one parameter.
You don't need VBA code to make a web query dynamic by referencing a cell for the parameter, as you describe, and it refreshing automatically when the cell value changes. Everything can be set up using the Excel UI - see http://www.jkp-ads.com/articles/webquery.asp