Pre-release ASAP Utilities version 4.2.3 RC1

Last week version 4.2.2. was released. Unfortunately this version contains a few bugs. I have solved these and a new version will be released soon.

The most annoying bug is in the utility "Range » Find / Replace in all sheets...". When you pressed the "Find all" button you immediately got Error 401: Application-defined or object-defined error which makes the utility unusable.
Error

You can download a pre-release of version 4.2.3 where these bugs are fixed.

4 Responses to “Pre-release ASAP Utilities version 4.2.3 RC1”

  1. Hi Bastien,

    May the couple live 1000 years.
    Following is a link to an article. Last para of the article contains some useful information regarding the function wizard, which I hope you must be implementing in yours coming versions.

    http://www.decisionmodels.com/calcsecretsj.htm

    Regards
    CA Kanwaljit Singh Dhunna

  2. Hi Bastien,

    May the couple live 1000 years.

    Chq Paid-MICR INW CL-NEELKANTH META
    CHQ DEP-HIGH VALUE CLG-CLEARING BR-D

    I converted the above using "Start Each word with Uppercase and following are the results.

    Chq Paid-micr Inw Cl-neelkanth Meta
    Chq Dep-high Value Clg-clearing Br-d

    Whereas I was expecting them to be like

    Chq Paid-Micr Inw Cl-Neelkanth Meta
    Chq Dep-High Value Clg-Clearing Br-D

    "-" should be treated as separating two words and not as a character which is part of a longer word.

    Regards
    CA Kanwaljit Singh Dhunna

  3. Hello Kanwaljit,

    Thank you for your post and example.
    At this moment the utility will capitalize words. That means that they have to be separated with a space. I will add a new tool to the wishlist to handle names.
    For now you can use Excel's function =PROPER() to have the text displayed as you want.

    Kind regards,
    Bastien Mensink

  4. I eagerly await the update! This utility is AMAZING, and I'm grateful that it's something I can use for free as a student. It makes these late nights crunching these spreadsheets that much more manageable.

Pinterest