Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
![]()
GS wrote:
It displays a different pg1, but the code works just the same. If you follow how the code executes, the links list *must* be loaded in gvLinks *before* you can run GetItemInfo. So on Sheet1... Load a main webpage View Source Get Item Links ..to load gvLinks. Then click on a link in WebBrowser1, View Source, then Get Item Info. Right click 'Back' to choose another link, View Source, then Get Item Info. And so on for each link on the parent page. If you switch parent page then start the whole process again! -- Garry Will give that a try. Meanwhile i deduced a few thing via search variants. 1) A space between terms (5060 REGULATOR 63060) is a default logical OR, so results NOT what one would normally think. 2) Case matters; since a lower case term is very unlikely to match anything, the "About" count can be in the region of 10^8. 3) Removing spaces (using & instead of AND) can also give a huge result. 4) Not sure about use of & in place of AND yet (untested). With a little jujitsu of terms, i have one search that says About 24 and the actual is 28; not bad; most of the results are useful. But futzing them around and use of well-placed spaces, the number is large, with multiple pages being identical to other pages (AT RANDUMB); some of the results would clearly lie with that "short" search - but ain't there (and vice-versa)! I have done 500 pages in one case to squeeze out two devices not seen anywhere else, except one with your scheme which got FOUR never seen elsewhere. Messy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EOF Parse Text file | Excel Programming | |||
Parse a txt file and save as csv? | Excel Programming | |||
parse from txt file | Excel Programming | |||
Parse File Location | Excel Worksheet Functions | |||
REQ: Simplest way to parse (read) HTML formatted data in via Excel VBA (or VB6) | Excel Programming |