Ben.
I've used webqueries quite a few times and found them extremely powerful.
One largely unknown thing is you can add conditioning underneath your query
template, here is one I created as a quick example.
WEB
1
c:/excel/examples/test.htm
Selection=AllTables
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
One other nice way to get information from the web is to use the XMLHTTP
object, seach in google for this as it's a nice easy way to get info into a
specific cell anywhere on the sheet using minimal
VB
Hope this helps.
Chris