Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109214 > unrolled thread

Read (and parse) file on the web

Started byRobert Baer <robertbaer@localnet.com>
First post2016-08-26 10:57 -0800
Last post2016-09-17 17:15 -0400
Articles 20 on this page of 92 — 6 participants

Back to article view | Back to microsoft.public.excel.programming

Contents

  Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-26 10:57 -0800
    Re: Read (and parse)  file on the web "Auric__" <not.my.real@email.address> - 2016-08-26 15:21 +0000
      Re: Read (and parse)  file on the web "Auric__" <not.my.real@email.address> - 2016-08-26 15:22 +0000
        Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-27 13:04 -0800
      Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-27 13:00 -0800
      Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-27 23:14 -0800
        Re: Read (and parse)  file on the web CORRECTION Robert Baer <robertbaer@localnet.com> - 2016-08-28 09:42 -0800
          Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-08-28 10:08 -0800
            Re: Read (and parse)  file on the web CORRECTION#2 "Auric__" <not.my.real@email.address> - 2016-08-29 01:51 +0000
              Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-08-28 21:32 -0800
                Re: Read (and parse)  file on the web CORRECTION#2 "Auric__" <not.my.real@email.address> - 2016-08-29 19:41 +0000
                  Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-08-30 00:21 -0800
                    Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-08-30 06:06 -0400
                      Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-08-30 14:20 -0800
                        Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-08-30 18:43 -0400
                          Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-08-31 16:47 -0400
                            Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-01 04:37 -0800
                              Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-01 13:13 -0400
                                Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-01 16:32 -0800
                                  Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-01 19:43 -0400
                          Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-01 04:23 -0800
                    Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-05 10:10 -0400
                      Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-05 10:17 -0400
                        Re: Read (and parse)  file on the web CORRECTION#3 Robert Baer <robertbaer@localnet.com> - 2016-09-05 20:50 -0800
                      Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-05 20:32 -0800
                        Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-06 10:49 -0400
                          Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-06 12:05 -0800
                            Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-06 15:15 -0400
                              Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-06 22:32 -0800
                                Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-07 11:44 -0400
                                  Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-07 09:33 -0800
                                  Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-08 20:18 -0800
                                    Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-09 06:07 -0400
                                      Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-09 22:05 -0400
                                        Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-14 17:16 -0800
                                          Re: Read (and parse)  file on the web CORRECTION#2 GS <gs@v.invalid> - 2016-09-14 20:23 -0400
                        Re: Read (and parse)  file on the web CORRECTION#2 "Auric__" <not.my.real@email.address> - 2016-09-07 02:37 +0000
                          Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-06 22:43 -0800
                            Re: Read (and parse)  file on the web CORRECTION#2 "Auric__" <not.my.real@email.address> - 2016-09-08 05:49 +0000
                              Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-08 01:07 -0800
                                Re: Read (and parse)  file on the web CORRECTION#2 "Auric__" <not.my.real@email.address> - 2016-09-09 06:40 +0000
                              Re: Read (and parse)  file on the web WGET versions Robert Baer <robertbaer@localnet.com> - 2016-09-08 01:19 -0800
                                Re: Read (and parse)  file on the web WGET versions Robert Baer <robertbaer@localnet.com> - 2016-09-08 20:09 -0800
                          Re: Read (and parse)  file on the web CORRECTION#2 Robert Baer <robertbaer@localnet.com> - 2016-09-06 23:49 -0800
        Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-08-28 15:51 -0400
          Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-28 21:37 -0800
          Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-02 19:09 -0800
        Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-08-29 01:56 -0400
          Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-08-29 02:21 -0400
            Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-29 19:55 -0800
              Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-08-29 23:35 -0400
                Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-29 22:25 -0800
          Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-29 19:21 -0800
            Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-08-29 23:21 -0400
              Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-29 22:10 -0800
                Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-08-30 04:04 -0400
                  Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-30 13:48 -0800
            Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-08-29 23:37 -0400
              Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-08-29 22:25 -0800
      Re: Read (and parse)  file on the web lovexes17816 <lovexes17816@gmail.com> - 2016-08-28 14:00 +0100
      Re: Read (and parse)  file on the web lovexes17816 <lovexes17816@gmail.com> - 2016-08-29 02:17 +0100
        Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-02 19:11 -0800
          Re: Read (and parse)  file on the web "Auric__" <not.my.real@email.address> - 2016-09-03 04:12 +0000
      Re: Read (and parse)  file on the web Tikivn23143 <Tikivn23143@gmail.com> - 2016-08-30 02:28 +0100
      Re: Read (and parse)  file on the web everonvietnam2016 <everonvietnam2016@gmail.com> - 2016-09-07 15:03 +0100
        Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-07 08:43 -0800
          Re: Read (and parse)  file on the web "Auric__" <not.my.real@email.address> - 2016-09-08 05:43 +0000
            Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-08 01:09 -0800
              Re: Read (and parse)  file on the web "Auric__" <not.my.real@email.address> - 2016-09-09 06:49 +0000
      Re: Read (and parse)  file on the web everonvietnam2016 <everonvietnam2016@gmail.com> - 2016-09-08 11:11 +0100
    Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-14 17:14 -0400
      Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-14 17:19 -0800
        Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-14 20:26 -0400
          Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-15 09:59 -0800
            Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-15 14:33 -0400
        Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-14 21:28 -0400
          Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-15 10:05 -0800
      Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-14 18:48 -0800
        Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-14 21:59 -0400
          Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-15 10:15 -0800
            Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-15 22:10 -0800
              Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-16 11:50 -0400
                Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-16 23:54 -0800
                  Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-17 11:06 -0400
                    Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-17 23:59 -0800
                      Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-18 03:22 -0400
                        Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-20 00:20 -0800
                  Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-17 11:14 -0400
                    Re: Read (and parse)  file on the web Robert Baer <robertbaer@localnet.com> - 2016-09-18 00:18 -0800
                      Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-18 03:30 -0400
        Re: Read (and parse)  file on the web GS <gs@v.invalid> - 2016-09-15 05:02 -0400
          Re: Read (and parse)  file on the web - revised GS <gs@v.invalid> - 2016-09-17 17:15 -0400

Page 4 of 5 — ← Prev page 1 2 3 [4] 5  Next page →

#109226

Fromlovexes17816 <lovexes17816@gmail.com>
Date2016-08-29 02:17 +0100
Message-ID<lovexes17816.12094a08@excelbanter.com>
In reply to#109215
Phim SEX không che , Phim SEX Nháº*t Bản , Phim SEX loạn luân ,
Phim SEX HD

>>>> 'Phim SEX online' (http://sexchonloc.com/) <<<<  -*Xem phim sex*-
chọn lọc chất lượng cao mới nhất 2016, Phim sex online
siêu dâm dục, phim sex hd siêu nét vừa xem vừa thủ dâm
cực khoái.




-- 
lovexes17816

[toc] | [prev] | [next] | [standalone]

#109277

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-02 19:11 -0800
Message-ID<mjqyz.45748$1b1.20406@fx43.iad>
In reply to#109226
   What is with this a*hole posting this sh*t here?

[toc] | [prev] | [next] | [standalone]

#109278

From"Auric__" <not.my.real@email.address>
Date2016-09-03 04:12 +0000
Message-ID<XnsA677D7CF1D248auricauricauricauric@213.239.209.88>
In reply to#109277
Robert Baer wrote:

> What is with this a*hole posting this sh*t here?

It's just spam. Ignore it.

-- 
If you would succeed,
you must reduce your strategy to its point of application.

[toc] | [prev] | [next] | [standalone]

#109236

FromTikivn23143 <Tikivn23143@gmail.com>
Date2016-08-30 02:28 +0100
Message-ID<Tikivn23143.120a9b89@excelbanter.com>
In reply to#109215
ChÃ*o bạn!

Có bạn phải đang tìm kiếm cho mình *'mã giảm giá adayroi'
(http://magiamgiaadayroi.com)* không? Hãy truy  cáº*p ngay
MaGiamGiaAdayroi.com để nháº*n tháº*t nhiều mã giảm giá miá»…n
phÃ* nhé




-- 
Tikivn23143

[toc] | [prev] | [next] | [standalone]

#109290

Fromeveronvietnam2016 <everonvietnam2016@gmail.com>
Date2016-09-07 15:03 +0100
Message-ID<everonvietnam2016.1215de58@excelbanter.com>
In reply to#109215
sản phẩm tốt, giá rẻ, chất lượng, an toÃ*n cho người
dùng, dịch vụ tuyệt trần, lúc nÃ*o có Ä‘iều kiện qua
ủng há»™ nhé. chúc cá»*a hÃ*ng lÃ*m ăn hiệu quả




-- 
everonvietnam2016

[toc] | [prev] | [next] | [standalone]

#109291

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-07 08:43 -0800
Message-ID<JAWzz.18131$yi7.7877@fx42.iad>
In reply to#109290
everonvietnam2016 wrote:
> sản phẩm tốt, giá rẻ, chất lượng, an toÃ*n cho người
> dùng, dịch vụ tuyệt trần, lúc nÃ*o có Ä‘iều kiện qua
> ủng há»™ nhé. chúc cá»*a hÃ*ng lÃ*m ăn hiệu quả
>
>
>
>
   No kapish.
   Firstly, on my computer, all i see is a strange mix of characters 
from the 512 ASCII set.
   Secondly, i would not be able to read or understand your language 
even if it was elegantly rendered.

[toc] | [prev] | [next] | [standalone]

#109294

From"Auric__" <not.my.real@email.address>
Date2016-09-08 05:43 +0000
Message-ID<XnsA67CE730DB43Cauricauricauricauric@213.239.209.88>
In reply to#109291
Robert Baer wrote:

> everonvietnam2016 wrote:
>> sản phẩm tốt, giá rẻ, chất lượng, an toÃ*n cho người
>> dùng, dịch vụ tuyệt trần, lúc nÃ*o có Ä‘iều kiện qua
>> ủng há»™ nhé. chúc cá»*a hÃ*ng lÃ*m ăn hiệu quả
>>
>    No kapish.
>    Firstly, on my computer, all i see is a strange mix of characters
> from the 512 ASCII set.
>    Secondly, i would not be able to read or understand your language
> even if it was elegantly rendered.

It's Vietnamese. *Lots* of accented characters. Also, it's spam.

-- 
Who says life is sacred? God? Hey, if you read your history,
God is one of the leading causes of death.
 -- George Carlin

[toc] | [prev] | [next] | [standalone]

#109297

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-08 01:09 -0800
Message-ID<719Az.103782$PM.53151@fx08.iad>
In reply to#109294
Auric__ wrote:
> Robert Baer wrote:
>
>> everonvietnam2016 wrote:
>>> sản phẩm tốt, giá rẻ, chất lượng, an toÃ*n cho người
>>> dùng, dịch vụ tuyệt trần, lúc nÃ*o có Ä‘iều kiện qua
>>> ủng há»™ nhé. chúc cá»*a hÃ*ng lÃ*m ăn hiệu quả
>>>
>>     No kapish.
>>     Firstly, on my computer, all i see is a strange mix of characters
>> from the 512 ASCII set.
>>     Secondly, i would not be able to read or understand your language
>> even if it was elegantly rendered.
>
> It's Vietnamese. *Lots* of accented characters. Also, it's spam.
>
   Yes, it was easy to recognize that was Vietnamese.
   How the heck did you figure out that it was spam?

[toc] | [prev] | [next] | [standalone]

#109303

From"Auric__" <not.my.real@email.address>
Date2016-09-09 06:49 +0000
Message-ID<XnsA67DF258EF049auricauricauricauric@213.239.209.88>
In reply to#109297
Robert Baer wrote:

> Auric__ wrote:
>> Robert Baer wrote:
>>
>>> everonvietnam2016 wrote:
>>>> sản phẩm tốt, giá rẻ, chất lượng, an toÃ*n cho người
>>>> dùng, dịch vụ tuyệt trần, lúc nÃ*o có Ä‘iều kiện qua
>>>> ủng há»™ nhé. chúc cá»*a hÃ*ng lÃ*m ăn hiệu quả
>>>>
>>>     No kapish.
>>>     Firstly, on my computer, all i see is a strange mix of characters
>>> from the 512 ASCII set.
>>>     Secondly, i would not be able to read or understand your language
>>> even if it was elegantly rendered.
>>
>> It's Vietnamese. *Lots* of accented characters. Also, it's spam.
>
>    Yes, it was easy to recognize that was Vietnamese.
>    How the heck did you figure out that it was spam?

Well, it's Vietnamese in an almost-entirely English group, replying to a 
thread that's entirely in English.

Also, courtesy of Google translate:

  Is good, cheap, quality, seated * n for users, divine service, at nÃ*o
  conditional support through offline. Wish c »* a hà * ng là * m efficiently

The text is buggered on my end so I can't get a complete translation, but you 
can see that it's meant to advertise *something*. The post immediately 
preceding it was also Vietnamese spam, complete with a link. (If you didn't 
see it, don't worry about it.)

Also, it's deleted from the Google archive. That's a pretty good sign right 
there.

-- 
The only thing your dreams will land you is dead in a ditch.

[toc] | [prev] | [next] | [standalone]

#109299

Fromeveronvietnam2016 <everonvietnam2016@gmail.com>
Date2016-09-08 11:11 +0100
Message-ID<everonvietnam2016.1216f798@excelbanter.com>
In reply to#109215
sản phẩm tốt, giá rẻ, chất lượng, an toÃ*n cho người
sá»* dụng, dịch vụ ráo trọi, lúc nÃ*o có Ä‘iều kiện qua
ủng há»™ nhé. chúc cá»*a hÃ*ng lÃ*m ăn hiệu quả




-- 
everonvietnam2016

[toc] | [prev] | [next] | [standalone]

#109307

FromGS <gs@v.invalid>
Date2016-09-14 17:14 -0400
Message-ID<nrceio$cet$1@dont-email.me>
In reply to#109214
>    Excel macros are SO... undocumented.
>    Need a WORKING example for reading the HTML source a URL (say 
> http://www.oil4lessllc.org/gTX.htm)
>
>    Thanks.

Look here...

    https://app.box.com/s/23yqum8auvzx17h04u4f

..for *ParseWebPages.zip*, which contains:

  ParseWebPages.xls
  NSN_5960.txt
    (Blank data file with fieldnames only in line1
  NSN_5960_Test.txt
    (Results for 1st 20 pages)

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[toc] | [prev] | [next] | [standalone]

#109309

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-14 17:19 -0800
Message-ID<YNlCz.24830$fL2.23612@fx20.iad>
In reply to#109307
GS wrote:
>> Excel macros are SO... undocumented.
>> Need a WORKING example for reading the HTML source a URL (say
>> http://www.oil4lessllc.org/gTX.htm)
>>
>> Thanks.
>
> Look here...
>
> https://app.box.com/s/23yqum8auvzx17h04u4f
>
> ..for *ParseWebPages.zip*, which contains:
>
> ParseWebPages.xls
> NSN_5960.txt
> (Blank data file with fieldnames only in line1
> NSN_5960_Test.txt
> (Results for 1st 20 pages)
>
   I did not even try cURL as the explanation was just too dern complicated.
   Fiddled in Excel,as it has so many different ways to do something 
specific.

   So, this is skeleton of what i have:
  Workbooks.Open Filename:=openFYL$ 'opens as R/O, no HD space taken

    then..
  With Worksheets(1)
'  .Copy    ''do not need; saves BOOK space
   .SaveAs sav$  'do not know how to close when done
   ' above creates the file described; that takes HD space, about 300K
  End With

   IMMEDIATELY after the "End With", a folder is created with useless 
metadata info; do not know how to close when done.

   WARNING: Scheme works only in XP and Win7.
   If in XP, at about 150 files,one gets a PHONY "HD is full" warning 
and one must exit Excel so as to be able to delete processed (and so 
unwanted) files.
   I say PHONY because the system showed NO CHANGE in HD free space, 
never mind those files take about 500MB.

   Furthermore, in Win7, these files show up in a folder the system 
KNOWS NOTHING ABOUT..Windows Explorer does not show C:\Documents which 
IS accessible; C:\<sysname>\MY Documents is shown and CANNOT be accessed.
   Instead of the Excel program crashing, the system is shut down and 
locked.
   YET other reasons I hate Win7.

[toc] | [prev] | [next] | [standalone]

#109311

FromGS <gs@v.invalid>
Date2016-09-14 20:26 -0400
Message-ID<nrcpru$f96$1@dont-email.me>
In reply to#109309
> GS wrote:
>>> Excel macros are SO... undocumented.
>>> Need a WORKING example for reading the HTML source a URL (say
>>> http://www.oil4lessllc.org/gTX.htm)
>>>
>>> Thanks.
>>
>> Look here...
>>
>> https://app.box.com/s/23yqum8auvzx17h04u4f
>>
>> ..for *ParseWebPages.zip*, which contains:
>>
>> ParseWebPages.xls
>> NSN_5960.txt
>> (Blank data file with fieldnames only in line1
>> NSN_5960_Test.txt
>> (Results for 1st 20 pages)
>>
>    I did not even try cURL as the explanation was just too dern 
> complicated.
>    Fiddled in Excel,as it has so many different ways to do something 
> specific.
>
>    So, this is skeleton of what i have:
>   Workbooks.Open Filename:=openFYL$ 'opens as R/O, no HD space taken
>
>     then..
>   With Worksheets(1)
> '  .Copy    ''do not need; saves BOOK space
>    .SaveAs sav$  'do not know how to close when done
>    ' above creates the file described; that takes HD space, about 
> 300K
>   End With
>
>    IMMEDIATELY after the "End With", a folder is created with useless 
> metadata info; do not know how to close when done.
>
>    WARNING: Scheme works only in XP and Win7.
>    If in XP, at about 150 files,one gets a PHONY "HD is full" warning 
> and one must exit Excel so as to be able to delete processed (and so 
> unwanted) files.
>    I say PHONY because the system showed NO CHANGE in HD free space, 
> never mind those files take about 500MB.
>
>    Furthermore, in Win7, these files show up in a folder the system 
> KNOWS NOTHING ABOUT..Windows Explorer does not show C:\Documents 
> which IS accessible; C:\<sysname>\MY Documents is shown and CANNOT be 
> accessed.
>    Instead of the Excel program crashing, the system is shut down and 
> locked.
>    YET other reasons I hate Win7.

I don't follow what you're talking about here! What does it have to do 
with the download I linked to?

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[toc] | [prev] | [next] | [standalone]

#109316

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-15 09:59 -0800
Message-ID<TrACz.110934$PM.86575@fx08.iad>
In reply to#109311
GS wrote:
>> GS wrote:
>>>> Excel macros are SO... undocumented.
>>>> Need a WORKING example for reading the HTML source a URL (say
>>>> http://www.oil4lessllc.org/gTX.htm)
>>>>
>>>> Thanks.
>>>
>>> Look here...
>>>
>>> https://app.box.com/s/23yqum8auvzx17h04u4f
>>>
>>> ..for *ParseWebPages.zip*, which contains:
>>>
>>> ParseWebPages.xls
>>> NSN_5960.txt
>>> (Blank data file with fieldnames only in line1
>>> NSN_5960_Test.txt
>>> (Results for 1st 20 pages)
>>>
>> I did not even try cURL as the explanation was just too dern complicated.
>> Fiddled in Excel,as it has so many different ways to do something
>> specific.
>>
>> So, this is skeleton of what i have:
>> Workbooks.Open Filename:=openFYL$ 'opens as R/O, no HD space taken
>>
>> then..
>> With Worksheets(1)
>> ' .Copy ''do not need; saves BOOK space
>> .SaveAs sav$ 'do not know how to close when done
>> ' above creates the file described; that takes HD space, about 300K
>> End With
>>
>> IMMEDIATELY after the "End With", a folder is created with useless
>> metadata info; do not know how to close when done.
>>
>> WARNING: Scheme works only in XP and Win7.
>> If in XP, at about 150 files,one gets a PHONY "HD is full" warning and
>> one must exit Excel so as to be able to delete processed (and so
>> unwanted) files.
>> I say PHONY because the system showed NO CHANGE in HD free space,
>> never mind those files take about 500MB.
>>
>> Furthermore, in Win7, these files show up in a folder the system KNOWS
>> NOTHING ABOUT..Windows Explorer does not show C:\Documents which IS
>> accessible; C:\<sysname>\MY Documents is shown and CANNOT be accessed.
>> Instead of the Excel program crashing, the system is shut down and
>> locked.
>> YET other reasons I hate Win7.
>
> I don't follow what you're talking about here! What does it have to do
> with the download I linked to?
>
   In the meantime, i took a stab of a "pure" Excel program to get the data.

   Whatever you do and more eXplicity how you do the search, it yields 
results that i do not see.

   Manually downloading the first page for a manual search, I get:

5960 REGULATOR AND "ELECTRON TUBE"
       About 922 results (1 ms)
5960-00-503-9529
5960-00-504-8401
5960-01-035-3901
5960-01-029-2766
5960-00-617-4105
5960-00-729-5602
5960-00-826-1280
5960-00-754-5316
5960-00-962-5391
5960-00-944-4671
5960-00-897-8418
	and
5960 AND REGULATOR AND "ELECTRON TUBE"
       About 104 results (16 ms)
5960-00-503-9529
5960-00-504-8401
5960-01-035-3901
5960-01-029-2766
5960-00-617-4105
5960-00-729-5602
5960-00-826-1280
5960-00-754-5316
5960-00-962-5391
5960-00-944-4671
5960-00-897-8418

   Note they are very different, and the second search "gets" a a lot less.
   Also neither search gets anything you got, and i am interested in how 
you did it.

[toc] | [prev] | [next] | [standalone]

#109319

FromGS <gs@v.invalid>
Date2016-09-15 14:33 -0400
Message-ID<nreph6$3jb$1@dont-email.me>
In reply to#109316
>   Also neither search gets anything you got, and i am interested in 
> how you did it.

If you study the file I gave you, you'll see how both methods are 
working. The worksheet implements all manual parsing so you can study 
each part of the process as well as the web page source structure; the 
*AutoParse* macro collects the data and writes it to the file.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[toc] | [prev] | [next] | [standalone]

#109312

FromGS <gs@v.invalid>
Date2016-09-14 21:28 -0400
Message-ID<nrctf7$eh8$1@dont-email.me>
In reply to#109309
If you're referring to the substitute 'page error' text put in place of 
missing item info, ..well that might be misleading you. Fact is, 
starting with item7 on pg7 there is no item info on any pages I checked 
manually in the browser (up to pg100). Perhaps you could rephrase that 
to "No Data Available"!?

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[toc] | [prev] | [next] | [standalone]

#109317

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-15 10:05 -0800
Message-ID<jxACz.8589$kR2.1601@fx41.iad>
In reply to#109312
GS wrote:
> If you're referring to the substitute 'page error' text put in place of
> missing item info, ..well that might be misleading you. Fact is,
> starting with item7 on pg7 there is no item info on any pages I checked
> manually in the browser (up to pg100). Perhaps you could rephrase that
> to "No Data Available"!?
>
   Machs nicht.
   I also looked manually and you are correct.
   Why the heck they have NSNs that do not relate to a part is puzzling, 
but, hey, it *IS* the government.
   Not useful to what i need, but still nice to know.

[toc] | [prev] | [next] | [standalone]

#109313

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-14 18:48 -0800
Message-ID<O5nCz.6535$gR2.2901@fx44.iad>
In reply to#109307
GS wrote:
>> Excel macros are SO... undocumented.
>> Need a WORKING example for reading the HTML source a URL (say
>> http://www.oil4lessllc.org/gTX.htm)
>>
>> Thanks.
>
> Look here...
>
> https://app.box.com/s/23yqum8auvzx17h04u4f
>
> ..for *ParseWebPages.zip*, which contains:
>
> ParseWebPages.xls
> NSN_5960.txt
> (Blank data file with fieldnames only in line1
> NSN_5960_Test.txt
> (Results for 1st 20 pages)
>
   Holy S*!
   I did about 30 pages by hand; quit as rather tiresome and total pages 
unknown (MORE than 999).
   Never saw the fail you saw.

   Difference is that you used the word "and"; technically (i think) 
that should not affect results.
   Also, you got items I am interested in, and after processing 503 
pages, i did NOT get those.

   In both cases, there were a lot of duplicate records (government 
data, what else can you expect?).

   In your sample, there were 73 useful records containing 43 unique 
records.  There may be some that i am not interested in, but there 
definitely ARE those i did not find that i am interested in.

   In my sample, there were 3782 unique records,and (better sit down), 
only 15 were interesting. Crappy odds.

   Hopefully, when i call them, someone that has some experience and 
knowledge of how their sort criteria works, will answer the phone.
   Last time i called,i got a new guy; no help other than "use Google".

   You have done a masterful job!
   Label it !DONE! please.

   Thanks a lot.

[toc] | [prev] | [next] | [standalone]

#109314

FromGS <gs@v.invalid>
Date2016-09-14 21:59 -0400
Message-ID<nrcv9f$ibs$1@dont-email.me>
In reply to#109313
> GS wrote:
>>> Excel macros are SO... undocumented.
>>> Need a WORKING example for reading the HTML source a URL (say
>>> http://www.oil4lessllc.org/gTX.htm)
>>>
>>> Thanks.
>>
>> Look here...
>>
>> https://app.box.com/s/23yqum8auvzx17h04u4f
>>
>> ..for *ParseWebPages.zip*, which contains:
>>
>> ParseWebPages.xls
>> NSN_5960.txt
>> (Blank data file with fieldnames only in line1
>> NSN_5960_Test.txt
>> (Results for 1st 20 pages)
>>
>    Holy S*!
>    I did about 30 pages by hand; quit as rather tiresome and total 
> pages unknown (MORE than 999).
>    Never saw the fail you saw.
>
>    Difference is that you used the word "and"; technically (i think) 
> that should not affect results.
>    Also, you got items I am interested in, and after processing 503 
> pages, i did NOT get those.
>
>    In both cases, there were a lot of duplicate records (government 
> data, what else can you expect?).
>
>    In your sample, there were 73 useful records containing 43 unique 
> records.  There may be some that i am not interested in, but there 
> definitely ARE those i did not find that i am interested in.

You could 'dump' the file into a worksheet and filter out the dupes 
easily enough.
>
>    In my sample, there were 3782 unique records,and (better sit 
> down), only 15 were interesting. Crappy odds.
>
>    Hopefully, when i call them, someone that has some experience and 
> knowledge of how their sort criteria works, will answer the phone.
>    Last time i called,i got a new guy; no help other than "use 
> Google".

Those are dynamic web pages and so are database driven. Surely there's 
a repository database for this info somewhere other than NSN?
>
>    You have done a masterful job!
>    Label it !DONE! please.
>
>    Thanks a lot.

Happy to be of help; -I found the project rather interesting!

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[toc] | [prev] | [next] | [standalone]

#109318

FromRobert Baer <robertbaer@localnet.com>
Date2016-09-15 10:15 -0800
Message-ID<_GACz.3064$YK2.1842@fx25.iad>
In reply to#109314
GS wrote:
>> GS wrote:
>>>> Excel macros are SO... undocumented.
>>>> Need a WORKING example for reading the HTML source a URL (say
>>>> http://www.oil4lessllc.org/gTX.htm)
>>>>
>>>> Thanks.
>>>
>>> Look here...
>>>
>>> https://app.box.com/s/23yqum8auvzx17h04u4f
>>>
>>> ..for *ParseWebPages.zip*, which contains:
>>>
>>> ParseWebPages.xls
>>> NSN_5960.txt
>>> (Blank data file with fieldnames only in line1
>>> NSN_5960_Test.txt
>>> (Results for 1st 20 pages)
>>>
>> Holy S*!
>> I did about 30 pages by hand; quit as rather tiresome and total pages
>> unknown (MORE than 999).
>> Never saw the fail you saw.
>>
>> Difference is that you used the word "and"; technically (i think) that
>> should not affect results.
>> Also, you got items I am interested in, and after processing 503
>> pages, i did NOT get those.
>>
>> In both cases, there were a lot of duplicate records (government data,
>> what else can you expect?).
>>
>> In your sample, there were 73 useful records containing 43 unique
>> records. There may be some that i am not interested in, but there
>> definitely ARE those i did not find that i am interested in.
>
> You could 'dump' the file into a worksheet and filter out the dupes
> easily enough.
*  Yes, i did that; getting those 43 unique records.

>>
>> In my sample, there were 3782 unique records,and (better sit down),
>> only 15 were interesting. Crappy odds.
>>
>> Hopefully, when i call them, someone that has some experience and
>> knowledge of how their sort criteria works, will answer the phone.
>> Last time i called,i got a new guy; no help other than "use Google".
>
> Those are dynamic web pages and so are database driven. Surely there's a
> repository database for this info somewhere other than NSN?
* Prolly not dynamic as NSNs do not change except possible additions on 
rare occasion.
   Certainly, a SPECIFIC search (so far) always gives the same results.
   Look at a previous response concerning 100% manual search results, 
first page only.
5960 AND REGULATOR AND "ELECTRON TUBE" About 104 results
5960 REGULATOR AND "ELECTRON TUBE" About 922 results
   Totally different and neither match your results.
   And your results look superior.

>>
>> You have done a masterful job!
>> Label it !DONE! please.
>>
>> Thanks a lot.
>
> Happy to be of help; -I found the project rather interesting!
>

[toc] | [prev] | [next] | [standalone]

Page 4 of 5 — ← Prev page 1 2 3 [4] 5  Next page →

Back to top | Article view | microsoft.public.excel.programming

csiph-web