query url internetaufruf
Michael
Warum nimmt er nicht die in Feld A1 angegebene Adresse!!!!
Was ist hier falsch?
Gruß Michael
Sub Makro7()
' Makro7 Makro
' Makro am 02.11.2009 von Michael aufgezeichnet
Dim adresse As String
adresse = Range("a1")
'Range("A1").Select
' ActiveSheet.Paste
With ActiveSheet.QueryTables.Add(Connection:=adresse, Destination:=Range("B1"))
' _
"URL;http://www.nrwtonight.de/index.php?RubrikID=5&RubrikSubID=10&RubrikSubSubID=1" _
, Destination:=Range("B1"))
.Name = "index.php?RubrikID=5&RubrikSubID=10&RubrikSubSubID=1"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = False
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.WebSelectionType = xlEntirePage
.WebFormatting = xlWebFormattingAll
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = True
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
End Sub