• WSAnklebuster

    WSAnklebuster

    @wsanklebuster

    Viewing 15 replies - 1 through 15 (of 20 total)
    Author
    Replies
    • I was not aware of the pervasiveness of fake news sites. Thanks for enlightening me.

      As a humorous aside, I wonder if you detected the irony of your closing paragraph.

       

    • in reply to: Beyond Compare is beyond comparison #2464405

      Thanks for your clarification and for your reasoning for buying BC4.

      I can’t imagine businesses used paper tape! LOL

      Cheers,

       

      Mitch

       

    • in reply to: Beyond Compare is beyond comparison #2462789

      This is a great review! I have a similar history with computers (saving programs on Paper tape from the time-sharing terminal in middle school; hand-coding ML on the Commodore 64; carrying around COBOL programs on punch cards in college.)

      I bought Beyond Compare In the early 2000’s to manage all the duplicate backups I had accumulated. My favorite feature was the ability to write scripts to automate tasks. This was vital for the implementation of a Tower of Hanoi backup scheme. LOL (I love backups!)

      I never saw the need to get Beyond Compare 3. I see your screen shots show BC2, but you mentioned upgrading?

       

      Cheers,

       

      Mitch

       

      1 user thanked author for this post.
    • in reply to: The Last Langalist #2438649

      Happy retirement, Fred!

      I was a teenager when I started reading BYTE Magazine. I enjoyed seeing your name when I finally bought a computer and got online in the early 90’s.

       

      Cheers,

       

      Mitch

       

      1 user thanked author for this post.
    • in reply to: Freeware Spotlight — Autorun Organizer #2405154

      Hi Deanna,

      Thanks for this Autorun Organizer. I used to use Nirsoft’s utilities.

      To answer your question about right-clicking an entry and then selecting Add to Startup…, this allows you to add a new program to Startup. 🙂

       

      Cheers,

       

      Mitch

       

    • in reply to: Saw this at my sister’s house (Thanksgiving). #2323242

      STAND

      __________

      I

    • in reply to: Is this the best science fiction show ever? #2307587

      Seriously? The best SF Series ever is Cleopatra 2525.

      {runs from the lounge, giggling}

    • in reply to: My Journey into the World of Linux #1580469

      mrjimphelps, this is cool! I recently zapped Windows from my old laptop, with the intention of installing Ubuntu Linux (he-he).

      Currently, I am running it from a USB key, which I used during the zap phase. I will be following along and learning!

      Cheers,

      Mitch

    • in reply to: Modify Code to Find Last Row in Range #1570957

      RG,

      Here it is:

      https://msdn.microsoft.com/en-us/library/dd361851.aspx

      Cheers,

      Mitch

    • I use Evernote for this – select what to save, click the elephant, click Save, tag the resultant EN Note as ‘Windows Secrets’, copy & paste Newsletter number and date into Note Title. Done.

      If I wanted an EN Note as a PDF I would print the EN Note to a PDF printer – not that I ever have.

      For some inexplicable reason, in Firefox, I cannot avoid selecting the line before Newsletter number and date (it’s the title of the first item) hence the cut and paste step. Maybe in Chrome I could, but for various reasons I keep Chrome free of extensions. Firefox is my goto browser.

      Would it not be more logical if WS made the ‘title’ of the newsletter page the newsletter number and date, rather than the title of the first item. Probably, but…

      NW

      NW, are you clicking to the article page before saving in Evernote? If you save from the “home” page, perhaps because you just want the top story, Web Clipper takes that title, as you said.

      If you click on the article title first, then Web Clipper uses that article’s page title:
      43574-lounge-save-evernote

      Bonus: you won’t have to tediously select what you want.

      Cheers,

      Mitch

    • in reply to: Download from website #1551550

      Due to the the large database size, this has to be an all or nothing proposition. The following suggestion is subject to two huge assumptions:

      1. The web site will allow thousands of searches from the same IP in a short period of time
      2. The client can find a developer to properly implement the scheme

      Maudibe had the right idea: partitioning the data. I chose to focus on the other filters, since the initial letter really can’t be extended. After refining each filter, I checked against the letter A. Each result returned over 500 until I got to the last filter: time range. Arbitrarily, I chose 01/01/2006 – 01/31/2006.

      Finally! 3 results!

      43573-lounge-md-search

      Upon further reflection, this is a good range, as the number returned is less than a page. (If the developer can use sockets, this will be irrelevant.)

      At the worst, nearly 20,000 searches have to be done for each time range. Here is a summary:

      Partitioning Scheme:

      26 Initial: Must use only one letter, due to single letter entities like A & L
      24 County: Maryland has 23 counties and one independent city
      4 Case Type: Civil, Criminal, Traffic, Civil Citation
      2 Court Type: Circuit, District
      4 Party Type: Attorney, Defendant, Plaintiff, Other
      ?? Time Range: 1 month

      So for each time range, create 26 * 24 * 4 * 2 * 4 = 19,968 searches.

      Optimizations are possible. OP didn’t mention whether client was interested in the entire database. For example, if only one county is required, the searches per time range would go down to 832!

    • in reply to: Grouping changes in VBA #1540317

      Thanks, Rory. I added this to my Evernote.

    • in reply to: Grouping changes in VBA #1540270

      Rory, this is intriguing. Where can I learn more about WithEvents and, specifically, your implementation in the class handler? (Translation: I am clueless…)

      [edited to eradicate cluelessness]

      I wanted to figure out why the collection object was used. I found the answer in StackOverflow, along with a generally useful tutorial for event handlers in Excel VBA:

      Note that the reason you need to add the event handler instances to a collection is simply to ensure that they remain referenced and thus don’t get discarded by the garbage collector before you’re finished with them.


      Cheers,

      Mitch

    • in reply to: Offsite (cloud) vs. NAS storage #1536997

      After losing a decade’s worth of archived programs when my WD MyBook failed, I swore I would never again waste money on external drives. So, the short answer is that I store everything except backup images.

      I created free accounts on about half a dozen services, evaluated their usefulness and allocated my offline file storage according to how easy it was to retrieve them.

      Eventually, I stopped using services with buggy or resource-heavy desktop “apps” (MediaFire and SpiderOak, respectively.) Currently, I pay for just one service – Google Drive – but I’m probably going to switch to Dropbox Pro to save money and increase storage.

      I let CryptSync handle the syncing and encrypting between my local drive and the services’ folders. While that adds a layer of complexity for recovering files, I just use RoboForm to keep track of the CryptSync passwords!

      The only fly in the ointment is that I will have to buy an external drive in order to do full image backups (I miss the old Norton Ghost! and Windows 98SE…sigh)

      Cheers,

      Mitch

    • in reply to: Making Monopoly game on Excel spreadsheet #1511851

      Zeddy,

      You are a rockstar. Every time I read this forum, you seem to have something cool to share!
      When I saw this thread highlighted in WindowsSecrets, I thought someone would come up with either an animated GIF or, a solution based on Excel’s Camera tool.

      Yours is a cool hybrid of those. I’ve seen the camera in action (on Chandoo.org) but I can’t “picture” using it for a dice-roller, can you?

      Cheers,

      Mitch

    Viewing 15 replies - 1 through 15 (of 20 total)