AW: Splitten web import
06.10.2008 20:26:28
Tino
Hallo,
wie wäre es hiermit?
Modul Modul1
Option Explicit
Sub leseWebdaten()
Dim appIE As Object
Dim strHTML As String
Dim varDaten, A As Long
Application.ScreenUpdating = False
Columns("A:C").Clear
Set appIE = CreateObject("InternetExplorer.application")
appIE.Visible = False 'False ist unsichtbar True ist Sichtbar
appIE.Navigate "http://www.ecb.int/euro.html "
While Not appIE.ReadyState = 4 'Warte auf Webseite
DoEvents
Wend
strHTML = appIE.Document.Body.InnerHtml
appIE.Quit
strHTML = Right$(strHTML, Len(strHTML) - InStr(strHTML, "</H1>") - 4)
strHTML = Left$(strHTML, InStrRev(strHTML, "<BR>") - 1)
varDaten = Split(strHTML, "<BR>")
For A = Lbound(varDaten) To Ubound(varDaten)
Cells(A + 2, 1) = varDaten(A)
Next A
Columns("A:A").TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, OtherChar _
:="(", FieldInfo:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
Columns("B:B").TextToColumns Destination:=Range("B1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 1), Array(3, 9), Array(6, 1)), DecimalSeparator:=".", _
ThousandsSeparator:=",", TrailingMinusNumbers:=True
Columns("A:C").AutoFit
Application.ScreenUpdating = True
End Sub
Gruß Tino