listed options question, page-9

  1. 19,434 Posts.
    lightbulb Created with Sketch. 206
    mike68, I don't know what you are using, but I am moving away from querytables and now using pscrape. Much more flexible with the grep strings for url's that change, or the increasing trend of embedding a second dynamic url within the page of an initial dynamic URL. I see a trend now where some sites are moving away from text altogether. Will need optical character recognition to get some data in a few years.

    ...


    cmdstr = "pscrape.exe -u""" & fname & """ -e""" & "(.*)"" -f ""1st match:\$1"" -o""" & Filename & """ "

    ...

 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.