Results 1 to 10 of 604

Thread: Appendix-Thread-Evaluate-Range-(-Codes-for-other-Threads-HTML-Tables-etc-)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    9,458
    Rep Power
    10
    In support of this Thread post
    https://eileenslounge.com/viewtopic....290499#p290499


    Method a)
    This is the way you do it, just in case it is more successful in the future for anything else .
    I use here the example of what you are looking for. As you can see, we almost get there, but just crap out at the very last step

    _1 Go to the Site of the search/ archive engine, web archive org - http://web.archive.org/
    That should bring up their “WayBackMachine”
    https://i.postimg.cc/XYB2tJgs/Site-web-archive-org.jpg

    _ 2 Put that link given from the book in the search bar of their “WayBackMachine”
    https://i.postimg.cc/RVFpQGJ5/Put-li...search-bar.jpg
    Attachment 3785

    _3 Hit Enter
    You will then see something like this if it found anything.
    https://i.postimg.cc/DZxTzgMv/Lots-o...rcaive-Bot.jpg
    In this case it seems to have found a lot, - so at this stage it looks very hopeful

    _ 4 Pick one of the years where there are hits shown . That is just guess work – try to think of a year that what you are looking for may have been available. In this next screen shot I chose randomly the year 2003
    https://i.postimg.cc/ZYjDdXRx/Chose-...hits-in-it.jpg
    Now you will see the dates ringed.
    https://i.postimg.cc/q781M5Sn/Ringed...e-was-done.jpg
    Those are the dates on which the search/ archive engine, web org, made a random capture of the web site

    _ 5 Hover over any of them there ringed dates, and click on a time shown
    https://i.postimg.cc/hvCyRQw5/Pick-a-date-and-time.jpg
    Attachment 3786

    _6 After this you have to take it as it comes and see how far you get.
    In this example, I got this, and noticed a link to Examples :
    https://i.postimg.cc/3wMLhTSY/Examples-1.jpg
    On another attempt after picking a different time and date I got something different but once again found a link to the examples.
    https://i.postimg.cc/ncPRd7qs/Examples-2.jpg
    Attachment 3787

    When I clicked on either of those links I see this, which is still looking hopeful: We are almost there.
    https://i.postimg.cc/mkZXnyd9/Almost-there.jpg
    Attachment 3788

    Unfortunately, every attempt so far by me craps out when I hit that zip link
    https://i.postimg.cc/PxQVKRMh/Craps-...st-attempt.jpg
    Attachment 3789

    I tried a couple of dozen times, and so far it always craps out at the last step. Shame we almost got there- I would take a guess that you won’t find the file this way. When I tried the same with the examples for the Excel book, I got the file on about every second attempt.
    As I mentioned it’s a bits hit and miss.
    I will look again randomly today when I have a few minutes and let you know if I strike lucky. But I don’t hold out much hope in this case.
    Always worth a try. More times than not the web archive works for me. I often use it when passing a link to a current web site and pass the link to the archived stored capture in preference to the actual link because then I know they get what I want them to get. Its invaluable for example, for Microsoft links, since they seem to have nothing better to do then change what actually appears at their help links, some times for the better, sometimes for the worse.




    Edit
    Method b) Frantic net search

    Examples.zip - https://app.box.com/s/w75bf0yb8dv875u0myyyg6xxmr9csiw3
    RomanWortdBook.dot - https://app.box.com/s/t09e5w0hrr71slos3tlnb5ds9byw5s3p
    BobsdBook.doc - https://app.box.com/s/2wwnfuxupruw8jzfmlhlown9trv8yx3t
    Attached Images Attached Images
    A Folk, A Forum, A Fuhrer ….

Similar Threads

  1. Testing Concatenating with styles
    By DocAElstein in forum Test Area
    Replies: 2
    Last Post: 12-20-2020, 02:49 AM
  2. testing
    By Jewano in forum Test Area
    Replies: 7
    Last Post: 12-05-2020, 03:31 AM
  3. Replies: 18
    Last Post: 03-17-2019, 06:10 PM
  4. Concatenating your Balls
    By DocAElstein in forum Excel Help
    Replies: 26
    Last Post: 10-13-2014, 02:07 PM
  5. Replies: 1
    Last Post: 12-04-2012, 08:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •