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 | |||
Excel formula to change page # when data entered in other page | Excel Discussion (Misc queries) | |||
How do I copy a graph of a data page to a new data page. | Charts and Charting in Excel | |||
Page Break Preview Page Number as Data | Excel Programming | |||
excel fit to 1 page shows 1 page but not all data is on that page | Excel Programming | |||
Printing second page if data overruns, otherwise print first page | Excel Programming |