View Single Post
  #68   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 CORRECTION#2

GS wrote:
Currently, it's ready to fully automate, but seems to have a snag
writing past the 1st parent page's child pages.


Turns out the problem was code not waiting for the browser not busy. I
switched to using URLDownloadToFile() at this point because it's orders
of magnitude faster. Using the browser/twxtbox on a sheet served well
for getting the process code nailed down, but that was only a temp
situation during dev.

"Problem" with Excel, is that there are MANY ways to get what is
needed, and there is NO WAY of discovering _any_ of them; the "help"
document is worse than useless in that manner.
I have found that URLDownloadToFile() to be non-functional for https
sources.


The links error out about mid pg7 thru pg10 as I time tested only pgs
1thru10: -this took 50.89 secs!

I'll do some housekeeping of the code and post a download link to the
file...