Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi
i have found this examble: Sub HentInfo() Dim oIE As SHDocVw.InternetExplorer Dim sPage As String Dim intStart, intSlut As Long Dim Info As String Set oIE = New SHDocVw.InternetExplorer oIE.Navigate "http://www.dr.dk" Do Until oIE.ReadyState = READYSTATE_COMPLETE DoEvents Loop sPage = oIE.Document.body.InnerHtml intStart = InStr(1, sPage, "Vejret") intSlut = InStr(intStart, sPage, "læs mere") Info = Mid(sPage, intStart, intSlut - intStart + 8) MsgBox Info End Sub But get an error in Info = Mid(sPage, intStart, intSlut - intStart + 8) To bee honest i don't know what the script do all the way regards alvin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
geting a if/and number off of two list cells | Excel Worksheet Functions | |||
geting the smaller number in a line?? | Excel Discussion (Misc queries) | |||
Question that should be easy but is geting on my nerves :) | Excel Discussion (Misc queries) | |||
geting hiperlink wiyh vlookup | Excel Worksheet Functions | |||
Erroe on Geting External Data | Excel Programming |