Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to get some data from a web site.
Because the data is part of a table on a web site, not the main table, I think that's why I can't find it. Code similar to what I am trying is: a = "" url = link Dim IE As Object 'this part open explorer and navigates to the web site I want Set IE = CreateObject("internetexplorer.application") With IE .Visible = False .navigate url Do While .ReadyState < 4: Loop a = .document.body.innertext End With 'I would then search for the text preceeding the value I am looking for Position = InStr(1, a, "Enemy Kills:", vbTextCompare) Like I said, I think because the text is in another section of the web page it doesn't find it. Some data I found from the Source of the web site is: <table id="member-jacket" class="info info-member" cellspacing="1" I am hoping this will help find the solution. Thanks in advance for any thoughts. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
importing data into excel2003 from some web site? | Excel Discussion (Misc queries) | |||
Importing Web Site Data | New Users to Excel | |||
How do I retrieve data into a cell from a web site? | Excel Worksheet Functions | |||
Getting data from web site to excel | Excel Programming | |||
accessing data on a web site | Excel Programming |