logo ASAP Utilities

Sit down and relax while ASAP Utilities does the rest!

Sit down and relax, while ASAP Utilities does the rest!

The ASAP Utilities User Guide (PDF) is a practical manual that will show you how to get the best out of this excel add-in.
To receive the User Guide by mail, send an email to
userguide@asap-utilities.com and you will get an automated reply with the file (19.5 MB) attached.

Not able to download?

We can send you the new version by email. The file is 3.0 MB
Send your request to:
download@asap-utilities.com
This setup does not include the User Guide.

If you want to uninstall ASAP Utilities, use the option "remove ASAP Utilities from your computer" in your ASAP Utilities start menu. Detailed information is also available on our website and in the User Guide.

Since 2001 it's our policy to force an upgrade (free) every half year to make sure you are always using the best and most complete version. This does not apply to users with a license, they can choose their own time to upgrade to the new version.

New ASAP Utilities version released!

ASAP Utilities version 4.5.1 (April 11, 2009) has just been released!

This new version is improved in many ways. Most of the tools have been updated, improved and redesigned. A major improvement is that you can now switch between two languages: English and Dutch(Nederlands)!


This year, in 2009, ASAP Utilities celebrates its 10th anniversary. In February 1999 the first public version was released on the internet. Our goals is to further improve ASAP Utilities and have it translated into several languages so that more people can benefit from it. Since we are from the Netherlands, the first and easiest step for us was to add the Dutch language.

We recommend everybody to download and install the new version.
DOWNLOAD
ASAP Utilities 5.5.1
 (20.2 MB)

In this newsletter


My thanks go out to each and every one of you for your suggestions and bug-reports the past years. ASAP Utilities continues to grow and improve thanks to your support, your suggestions and your encouragement. Unfortunately we are not able to reply to all the emails we receive, but we read (and use) them all.

Our goal is to make work easier for Excel users, both beginner and expert.
ASAP Utilities contains no spyware, adware or viruses, and is digitally signed.

Kind regards,

Bastien Mensink
ASAP Utilities
A Must in Every Office BV, The Netherlands
http://www.asap-utilities.com

“We make you the company's Excel guru!”

Upgrade to the new version

Upgrading is a simple 2 step process: first download and then install.

If you are not able to download the file from our website, we can send you the new version by email. The file is 3.0 MB. Send your request to:
download@asap-utilities.com and you will get an automated reply with the new version attached.

New and improved utilities

Bug fixes in version 4.5

  • Import » Merge files together in a new file...
    When you import Excel files the column width is now preserved.
  • Import » Merge files together in a new file...
    If you imported a file with the extension CSV, your custom settings were ignored, and the file was always split by your Windows list separator. This is now fixed.
  • ASAP Utilities » Import » Insert Textfile (with options)...
    Fixed the error Method '~' of object '~' failed. This could happen if you started Excel and then immediately imported a file without any editing of the blank workbook Excel started with. Excel then just opened the file and closed the blank workbook which caused the error in ASAP Utilities.
  • General, menu
    If the Excel menu bar was protected (a very rare situation) you could get an error stating that the ASAP Utilities menu could not be created: "Sorry, I can't create the menu due to an error... Method '~' of object '~' failed."
    This is now fixed. We have created a workaround for this by temporarily removing the protection, creating the menu and then applying the original protection settings again.
    Sorry, I can't create the menu due to an error... Method '~' of object '~' failed.
    An example of a setting that can be used to protect the menu and resulted in the error in ASAP Utilities: Application.CommandBars(1).Protection = msoBarNoCustomize
  • Columns & Rows » View and manage hidden rows and columns...
    Fixed the error when you used the utility in Excel 2007 on a workbook that was opened in compatibility mode and it had only 255 columns instead of 16384.
  • Text » Delete number of leading characters...
    If you used the utility on a range that contained a cell with a date you got an error. This is now fixed by skipping all cells with a date.
  • Text » Delete number of ending characters...
    If you used the utility on a range that contained a cell with a date you got an error. This is now fixed by skipping all cells with a date.
  • Text » Delete all after n'th character...
    If you used the utility on a range that contained a cell with a date you got an error. This is now fixed by skipping all cells with a date.
  • Sheets » Sort all sheets...
    The utility produced an error if you workbook contained a hidden sheet that had the visible property set to xlVeryHidden: "Move method of Worksheet class failed". This is because a xlVeryHidden sheet can not be moved. Therefore this utility now skips the sheets that are hidden like that.
  • Select » Select all sheets
    Didn't work and gave an error when one or more sheets in your workbook were hidden. This is now fixed.
  • Text » Make first character Uppercase, the rest lowercase
    Gave an error if the formatting of the cells was protected. This is now fixed.
    The utility also gave an error on cells with very long text, this is fixed too.
  • Text » Convert to UPPERcase
    The utility didn't work and gave an error on cells with very long text values. This is now fixed.
  • Text » Convert to lowercase
    The utility didn't work and gave an error on cells with very long text values. This is now fixed.
  • Text » Start first word with Uppercase
    The utility didn't work and gave an error on cells with very long text values. This is now fixed.
  • Text » Start Each Word With Uppercase
    The utility didn't work and gave an error on cells with very long text values. This is now fixed.
  • Web » Activate hyperlinks (create from cell values)
    The =HYPERLINK() option does not work if the length of the address exceeds 255 characters. This would result in an error. ASAP Utilities will now warn you upfront if any of the cells is too long to use the formula option.
  • Web » Convert hyperlinks to =HYPERLINK() formulas
    The =HYPERLINK() option does not work if the length of the address exceeds 255 characters. This would result in an error. ASAP Utilities will now skip cells that are too long and inform you at the end how many cells were skipped because the address was too long.
  • Fill » Fill up with leading zeros...
    Once you filled up the numbers with leading zeros the utility didn't always work when you ran the utility on the same data again and wanted less leading zeros. This is now fixed.
  • Undo
    Improved, especially on cells with very long values (more than 1024 characters).
  • Several improvements and small bugs fixed.
Secure online ordering via Regnow

When is ASAP Utilities free and when do you need to purchase a license?

You should purchase a license and register ASAP Utilities either:
  • if you use it for commercial purposes (Feel free to try it for 90 days. If you like it, simply purchase a registration key online via our e-commerce partner RegNowSecure ordering)
  • or if you don't want to be forced to update to the new version twice a year
  • or if you like this program and think it is worth the money
  • or because you know the money will be invested in further development,
  • or if you want to get priority support.

Key benefits of registration

  • use it in a commercial organization
  • no forced updates twice a year
  • priority support via email
  • free upgrade to all 4.x versions

Online ordering, safe secure and fast

The registration process is quick and easy. Online ordering is the fastest and most secure way you can get a license key for ASAP Utilities.
  • Single user license: US $49.00
  • The price is a one time fee, not a yearly subscription.
  • We offer generous volume discounts (save 20% to 86%)
  • You can pay in the following currencies: US Dollar (USD), Euro (EUR), Pound Sterling (GBP), Australian Dollar (AUD), Canadian dollar (CDN), Swedish Krona (SEK), New Zealand Dollar (NZD), Norwegian Krone (NOK), Yen (JPY), Hong Kong Dollar (HKD), Danish Krone (DKK), Swiss Franc (CHF), Rand (ZAR), Singapore Dollar (SGD) and Yuan Renminbi (CNY)
  • There is no shipping or handling fee
  • You can also get ASAP Utilities on a cd-rom by postal mail for an additional USD 12.50
  • After the order is completed you get your registration code within a few minutes.

Instant delivery

Your registration code is sent to you by email immediately after the order is completed and the payment is received.
This is usually within a few minutes when you pay with a credit card.

More information and demonstration

More information about pricing, volume discounts, payment methods and how to get a license for ASAP Utilities.
We have also made a demonstration of the steps in the ordering process.


Share this page:
Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
ę 1999-2014 - - - - The Netherlands EnglishDutch - NederlandsGerman - DeutschSpanish - Espa˝olFranšais (French)

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook