ASAP Utilities

Pre-release ASAP Utilities version 4.2.3 RC1

by Bastien 4 Comment

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.

Related Posts

4 comments

Kanwaljit

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

Kanwaljit

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

Bastien

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

EstCat

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.