ASAP Utilities 4.2.1 has been released today!

We're proud to officially announce the new version of ASAP Utilities!

You can download 4.2.1, November 14, 2007.

This new version is improved in a few ways.
We recommend especially people with Excel 2007 to upgrade to this new version.

I would like to thank everybody for their feedback the past months!

If you would like to be informed by email when a new version is released, you can subscribe to our newsletter.

New/improved in this version

• Fill » Random numbering of cells (without duplicates)
  Improved speed
• ASAP Utilities Options » (Re) build the ASAP Utilities favorites menu toolbar
  Create or update a toolbar with the buttons/tools from your favorites menu. The toolbar is automatically updated when you change your favorites menu or your shortcuts to the tools from ASAP Utilities
  
• Format » Copy a sheet's page and print settings...
  Slightly improved speed. Furthermore it displays the current printer at the bottom. The speed of changing the page-setup in Excel might depend on the printer you currently have active. I will write more about this...
  
• =ASAPRandomPassword(length, use_symbols)
  This new function will return a strong password which contains of
    - both uppercase and lowercase letters
    - numbers
    - symbols, such as ~ ! @ # $ % ^ & * ( ) [ ] \ / < > : - = + _
  
  lenght:       The length of the password. If omitted the length will be 8 characters. If the length given is less then 8, still a password of 8 characters will be returned.
  use_symbols:  Use symbols in the password. Recommended for strong passwords. If omitted the password will contain symbols (special characters)
  
  Examples of created passwords:
  =asaprandompassword()                        4j:4Js29
  =asaprandompassword(8,FALSE)          dvU57E6u
  =asaprandompassword(8,TRUE)           -\D5t0:3
  =asaprandompassword(14,FALSE)         55GHo1sM85j9Le
  =asaprandompassword(14,TRUE)          89eTgLq\_46woE
  
  This function can be easy if you need a random password, or for example of you are a system administrator and need to create 50 random passwords for new email addresses.
  
• Format » The smart difference...
  Contains a new option to apply colorbanding. Based on the information of data in a column you can have alternate colors to visualize the differences of data-groups.
  
• General
  A few small improvements.

Bugs fixed

• Sheets » Freeze panes on multiple sheets at once
  Improved. The wrong range was freezed when the selected range on the other sheet was not in the "visible area". This is now fixed
• System » Save file and create backup
  Fixed the bug where in Excel 2007 the point was removed before the extention in the name of the backup. When the filename had an extension that was not 3 characters, for example xlsx in stead of xls it goes wrong. For example book1.xlsx became in the backup folder: Book1 (backup 2007-10-01 08.25.31)xlsx; no piont before xlsx.
• Excel 2007 ribbon
  I have removed the dynamic getScreentip for the buttons. This caused empty Visual Basic popups when you wanted to customize the ribbon (quick access toolbar, qat) and choose "all commands". The same goes for the getImage tag. If you first select the ASAP Utilities tab and then customize the ribbon it is okay, if you directly customize the ribbon you will still see one empty Visual Basic error. However this error has no effect on how things work.
• Excel 2007 on Windows XP
  Fixed the statup delay in Windows XP + Excel 2007 when opening a file through the Windows Explorer.
  blog/index.php/2007/10/12/fix-excel-2007-explorer-startup-delay/
• General
  Fixed a few small bugs and typing errors.