You had mentioned you have used VB code In your experinece was that
sucessfull for you? I am almost at the point of scratching the approach of
doing the traditional querry and just hard code it. My other question is it
difficult to use VB code to extract the data needed from the web. Thanks guys
for both of your feedback. I am dertermined to figure this out one way or the
other.

Chris

"Chris" wrote:

I created an excel spreadsheet that captures prices from the web and what I
want to do is take these prices from the web queries I created and move them
into a workable list. The problem is when the queries are first created and I
hyperlink them into a list, it works great!!!! The problem occurs when a
couple of days later when I refresh, the data becomes skewed and some of the
lines shift. What should be a price is another piece of data from the web
query appears on the link. I have tried developing the queries both dynamic
and non dynamic but both ways I have problems with the data.

Ultimately, what I would like to do is have the queries build once,
hyperlinked into another sheet and then build a pivot table from the results.
If you have any insight or feedback on this, I would be most grateful. Like I
mentioned, if you do not know then I guess this cannot be done.

Best Regards,

Chris