See if this works for you:

1)Open a browser and go to the website.
2)Copy the URL (to notepad for safekeeping...just in case)
3)Switch to Excel
4)DataImport External DataNew Web Query
5)Paste your URL into the Address field in the New Web Query window
6)Click on the section of data you want to retrieve
7)Click the [Import] button
8)Select where you want to data to reside...and you're done.

After that...to refresh the data, just:
Right click on the data and select "Refersh Data"

Does that help?
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=487478