I am trying to use excel 2003 to process online orders with a macro but am having problems with the Web Query function as follows

Cell A1 = Order number - say "1273976"

Cell A2 use excel functions "concantenate" and "hyperlink" to create the hyperlink from this order number - say http://www.anyname.com/1273976.htm

I would like cell A3 to do a Web Query based on the hyperlink in Cell A2

I have been unable to create this either with macro's or by trying to get the web query function to use the URL found in cell A2

Any ideas gratefully appreciated !!!

Thanks