View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
Robert Baer Robert Baer is offline
external usenet poster
 
Posts: 93
Default Read (and parse) file on the web

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.