Hello everyone,

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.

Here's my code:

activecell.QueryTable.Connection="URL;http://www.google.com/products/catalog?cid=[""GoogleNumber""]"

Everything works fine until I click "refresh" and select the cell I want the query to use for the CID/Google Number.

Can anyone help?