web query question

[Mark]

I want to log data from a weather statio n into excel. Is it possible to
use web query and have the data go into a new column each time its
refreshed? How should I do this?

Mark

 

[Tim Williams]

Logs query data as rows rather than columns, but you get the idea...

If you need to schedule refreshes then look into
application.ontime



Tim

'*************************************
Sub LogData()

With ActiveSheet
.QueryTables(1).BackgroundQuery = False
.QueryTables(1).Refresh
.Range("B3").Copy .Range("D10000").End(xlUp).Offset(1, 0)
.Range("B4").Copy .Range("E10000").End(xlUp).Offset(1, 0)
.Range("B6").Copy .Range("F10000").End(xlUp).Offset(1, 0)
End With

End Sub
'**************************************