Changes in version 4.5.0 - April 9, 2009

Finished

On April 9, 2009 the new version 4.5.0 is released. Download

New and improved utilities

Bug fixes

• Objects & Comments » Select all objects on current worksheet
  This tool previously also removed the drop-down arrows in cell validation lists. This is now fixed.
• Import » Merge files together in a new file...
  When you import Excel files the column width is now preserved.
• Fill » List filenames in folder...
  The file types option was case sensitive. This now no longer is. So it doesn't matter if you search for *.xls or *.XLS for example.
• 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.
• Text » Insert before current value...
  Text » Insert before after value...
  When the option "skip empty cells" was set this was ignored by the program. 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.
• 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.
  
  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.

Other

• Format » Quick table (autoformat)
  This utility has been removed from the menu. The tool hasn't been updated for years and we don't think that anybody will miss it, also because newer Excel versions have built in schemes for quickly formatting a table.
  You can use the following tool partially as a replacement for this one:
  Columns & Rows » Color each n'th row or column in selection...