http://www.excelforum.com/excel-prog...html?p=2822671

I am trying to do the same thing but using a web query. I need the macro to run a query that runs off of a url that is in a cell?? any ideas?
the url is going to change so I need cell being referenced. It would be really helpfull when reference the cell use the format Cells(1,1).Value because i would eventually like to use loops once this problem is solved thanks!!