Almost finished: ASAP Utilities version 4.2.6

BusyI'm almost finished with the updated version of ASAP Utilities: 4.2.6
Most changes in this version are corrections and bug fixes.
More information and download:
//www.asap-utilities.com/faq-questions-answers-detail.php?m=185

We're also working on version 4.3 which will contain several improvements and a very big step forward (that I can' t reveal yet). This is consuming a great portion of our time, but I'm sure many people will benefit from it.

6 comments

Kanwaljit

Hi Bastien,

May the couple live 1000 years !

It seems you haven't read my earlier comments on earlier post as there was no reply.
Any how, A little suggestion. A Bundling suggestion. I have experienced that many a times more than one/two utilities are used for the "cleansing" of the same data like
"Start Each Word With Uppercase" + "Delete all Leading/Trailing spaces" + "Advanced Character Removal" + "Insert before current value"

Isn't it possible to bundle them at one place so as to use them at one go.

Best Regards
CA Kanwaljit Singh Dhunna
India

Bastien

Hello Kanwaljit,

I'm sorry I didn't respond to the suggestions but I have surely read them and taken notice.

To bundle the utilities is something that is very user specific.
Perhaps you can write your own macro to perform such an action if you do the same a lot. Otherwise you can use a macro to launch several of the tools in sequence. The following page shows how you can call the tools from ASAP Utilities from within your own macro:
//www.asap-utilities.com/run-as-part-of-a-macro-vba.php

Kind regards,
Bastien

Bastien

Moved to here by Bastien:

Hi Bastien,

May the couple live 1000 years.

Do add it to the wish list. There are other options to which can be done in plain excel, but asap make them less time consuming and hassle free. So no harm in fulfilling the wish.

Regards
CA Kanwaljit Singh Dhunna
India

Bastien

Hello Kanwaljit,

The problem with combining utilities is that if we made this for everyone there would be a zillion combinations that we would have to create since each persons has his own preferences.
It is difficult where to draw the line.

Kind regards,
Bastien

Kanwaljit

Hi Bastien,

May the couple live 1000 years !

"In continuation of the above regarding combining utilities"

Isn't it possible to add a check-box in front of each utilitiy to make it possible to select multiple utilities based on user-requirements (like Multiple Selection in Pivot Tables in Excel 2007)

Regards
CA Kanwaljit Singh Dhunna
India

Bastien

Hello Kanwaljit,

Thank you for your suggestion, however I think it would be difficult/complex to implement.
You can however write your own macro to launch the different tools of ASAP Utilities in the sequence you use a lot. You can then assign this macro to your own button or the QAT.
//www.asap-utilities.com/run-as-part-of-a-macro-vba.php

With your example above you could use the following macro to run the four utilities in sequence:

Sub Sequence_ASAPUtilities()
' Start 4 tools from ASAP Utilities in sequence:

' # Start Each Word With Uppercase (84)
Application.SendKeys "{ENTER}" ' immediately press okay
Application.Run "'ASAP Utilities.xla'!ASAPRunProc", 84

' # Delete leading and trailing spaces (86)
Application.SendKeys "{ENTER}" ' immediately press okay
Application.Run "'ASAP Utilities.xla'!ASAPRunProc", 86

' # Advanced character removal/replace… (90)
Application.Run "'ASAP Utilities.xla'!ASAPRunProc", 90

' # Insert before current value… (79)
Application.Run "'ASAP Utilities.xla'!ASAPRunProc", 79

End Sub

Kind regards,
Bastien