Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |