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

Give whatever coding you already have and the url along with what you want

--
Don Guillett
SalesAid Software

"Scott" wrote in message
...
Tim/Johannes,

This is exactly what I want to do. The problem with the code provided
below
is that it did not show how to copy data from the web and paste it in
Excel.
Your help is appreciated.

Scott

"Tim Williams" wrote:

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