Dear all,

I have a list of html-links in Excel. Behind these links always the same
webpage arises (with different data). Now I wish to retrieve that data in
Excel via a macro (1000+ links)

Can anyone help me with this?

Thanks,
Johannes

Sub GetWebData()

Dim wb As Workbook
Dim c As Range
'adjust range to suit
For Each c In ThisWorkbook.Sheets("Links").Range("A1:A1000")
With Workbooks.Open(c.Value)
'get your data here
.Close False
End With
Next c
End Sub
Tim.

"Johannes" wrote in message
...
Dear all,

I have a list of html-links in Excel. Behind these links always the same
webpage arises (with different data). Now I wish to retrieve that data in
Excel via a macro (1000+ links)

Can anyone help me with this?

Thanks,
Johannes