AW: Internetliste auslesen
25.10.2013 10:49:33
ChrisL
Hi Tom
Probier mal...
Sub Makro1()
Dim i As Byte
For i = 1 To 49
Call WAbfrage(i, Range("A65536").End(xlUp).Offset(3, 0))
Next i
End Sub
Private Sub WAbfrage(ipage As Byte, rng)
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://vote.swr.de/swr/voting/abstimmung/ergebnis/t444448-0?page=" & ipage, Destination _
:=rng)
.Name = "t444448-0_1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlSpecifiedTables
.WebFormatting = xlWebFormattingNone
.WebTables = "10,14,18,22,26,30,34,38,42,46,50,54,58,62,66,70,74,78,82,86"
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub
cu
Chris