Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EOF Parse Text file Bam Excel Programming 2 September 24th 08 04:13 AM
Parse a txt file and save as csv? Frank Pytel Excel Programming 4 September 14th 08 09:23 PM
parse from txt file geebee Excel Programming 3 August 19th 08 07:55 PM
Parse File Location Mike Excel Worksheet Functions 5 October 3rd 07 04:05 PM
REQ: Simplest way to parse (read) HTML formatted data in via Excel VBA (or VB6) Steve[_29_] Excel Programming 3 August 25th 03 10:43 PM


All times are GMT +1. The time now is 01:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"