ASAP Utilities for Excel 97 version history

  

---

ASAP Uilities 3.10P for Excel 97 (June 2, 2010)

- Function: =MERGECELLS()
  This function didn't work as expected when the parameter
  'optional skip_empty_cells' was set to FALSE.
  

---

ASAP Utilities 3.10N for Excel 97 (November 10, 2009)

- Function: =ASAPGETFORMULA(cell)
  Updated, the utility used to always show the formula in A1 notation. Now
  it will be displayed according to the settings in your workbook (A1 or R1C1).
- Function: =ASAPGETFORMULAINT(cell)
  Updated, the utility used to always show the formula in A1 notation. Now
  it will be displayed according to the settings in your workbook (A1 or R1C1).
  

---

ASAP Utilities 3.10M for Excel 97 (March 9, 2009)

Bug fixes:

- Objects & Comments » Delete all objects on current worksheet
  This tool previously also removed the drop-down arrows in cell validation lists.
  This is now fixed.
- Fill » List filenames in folder...
  The filetypes option was case sensitive. This now no longer is. So it doesn't
  matter if you search for *.xls or *.XLS for example.
  

---

ASAP Utilities 3.10L for Excel 97 (September 10, 2008)

Bug fixes:

- Objects & Comments » Delete all objects on current worksheet
  This utility also removed the comments on your sheet. However the
  "comment-indicators", the triangles, were still shown by Excel. It could
  happen then when you click on a cell to view the comment that Excel
  would crash.
  The utility has now been updated so that al objects, except the comments,
  are removed.

---

ASAP Utilities 3.10K for Excel 97 (March 10, 2008)

New features:

- New worksheetfunction =ASAPISBOLD()
  Returns true of the referenced cell is bold

Bug fixes:

- Improved worksheet fuctions.

  ASAPSumByCellColor()
  ASAPCountByCellColor()
  ASAPSumByFontColor()
  ASAPCountByFontColor()
  If you work with more than 2 decimals the utility isn't 100% accurate after the fifth
  decimal of the result. This is corrected in this version.
  These functions can now use a cell-addres to specify the color in stead of only using
  the colorindex. Furthermore the accuracy of these functions is improved.
  So for example if you have a range of cells with 10 green cells you want to sum you
  can use the formula either as
  =ASAPSumByCellColor(A1:E24;4)
  or if cell D4 contains the color you can use:
  =ASAPSumByCellColor(A1:E24;D4)
  

---

ASAP Utilities 3.10J for Excel 97 (October 30, 2007)

Bug fixes:

- Text » Advanced character removal/replace...
  Didn't work in Excel 97. Error 438 was shown and then it quit.
  This is now fixed.
  

---

ASAP Utilities 3.10I for Excel 97 (October 3, 2007)

This version is compatible with Excel 97 and all future versions.
It does not require any special user-rights during the setup. If you
have Excel 2000 or newer we recommend you to use the new version 4.0 also
available from our website. That new version has some great new and improved
utilities.

Bug fixes:

- ASAP > (Re) build the ASAP Utilities toolbar
  Did't work in the previous version. An empty toolbar was created.
  This is now fixed.
  

---

ASAP Utilities 3.10H for Excel 97 (September 13, 2007)

This version is compatible with Excel 97 and all future versions.
It does not require any special user-rights during the setup. If you
have Excel 2000 or newer we recommend you to use the new version 4.0 also
available from our website. That new version has some great new and improved
utilities.

New features:

- New worksheet formula: =ASAPCountByCellColor(Lookin_Range, ColorNr)
  Counts the amount of cells in the selected range that have a certain cell color.
- New worksheet formula: =ASAPCountByFontColor(Lookin_Range, ColorNr)
  Counts the amount of cells in the selected range that have a certain font color.

Bug fixes:

- General
  Fixed a bug that caused an incorrect "new version" announcement on some computers
  after an upgrade from a previous version.
- Import > Merge files together in a new file...
  Fixed a bug that caused pipe delimited text files to be also split on the tab-character
- Improved worksheet fuctions
  ASAPSumByCellColor(Lookin_Range, ColorNr)
  ASAPSumByFontColor(Lookin_Range, ColorNr)
  If you work with more than 2 decimals the utility isn't 100% accurate after the fifth decimal
  of the result. This is corrected in this version.
  These functions can now use a cell-addres to specify the color in stead of only using the colorindex.
  So for example if you have a range of cells with 10 green cells you want to sum you can use the
  formula either as
  =ASAPSumByCellColor(A1:E24;4)
  or if cell D4 contains the color you can use:
  =ASAPSumByCellColor(A1:E24;D4)
  

---

ASAP Utilities 3.10F for Excel 97 (March 19, 2007)

This version is compatible with Excel 97 and all future versions.
It does not require any special user-rights during the setup. If you
have Excel 2000 or newer and you do have administrator or power user
rights we recommend you to use the new version 4.0 also available from
our website. That new version has some great new and improved
utilities.

New features:

New worksheet functions:
- New worksheet function: =ASAPGetHyperlink(range, optional sNA)
  This function returns the hyperlink from a cell. The hyperlink can be one of the following:
  . existing file or web page
  . place in your document
  . e-mail address
  You can optionally specify a string value for the sNA, this text will be displayed for
  cells without hyperlinks. If omitted the formula will give an empty result for cells
  without hyperlinks.
  Example: =ASAPGETHYPERLINK(A2,"-")
- New worksheet formula: ASAPGetFontName(Range)
  Returns the font name from a given cell.
- New worksheet formula: ASAPGetFontSize(Range)
  Returns the font size from a given cell.
- New worksheet formula: ASAPGetNumberformat(Range)
  Returns the number format from a given cell.
- New worksheet formula: ASAPIsFormula(Range)
  Returns true if the given cell contains a formula or an array-formula,
  otherwise it returns false.
- New worksheet formula: =ASAPCountChar(SearchText, SearchValue)
  This function returns the number of times the “SearchValue” occurs in the “SearchText”.
  This way you can for example count the number of commas in a cell.
  This function is case sensitive.
- New worksheet formula: =ASAPExtractFilename(FullFilename, optional separator)
  Extracts the file name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFilename(B23) will return "Sort random(shuffle).xls"
- New worksheet formula: =ASAPExtractFolderName(FullFilename, optional separator)
  Extracts the folder name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFolderName(B23) will return "D:\User Guide\screenshots"
- New worksheet formula: =ASAPGetFormula(FormulaCell)
  Returns the formula in a cell in local Excel language. Example: =GEMIDDELDE("A1:B12")
  Returns empty if the cell does not contain a formula
- New worksheet formula: =ASAPGetFormulaInt(FormulaCell)
  Returns the formula in a cell in international notation. Example: =AVERAGE("A1:B12")
  Returns empty if the cell does not contain a formula
- New worksheet formula: =ASAPMergeCells(inputrange, delimiter, skipemptycells)
  An easy alterative for the Excel =CONCATENATE() fuction. However the benefit
  of this ASAP Utilities function:
  - you can specify a range, for example A1:G1
  - you only have to specify a delimiter once
  - by default empty cells will be ignored
- New worksheet formula: =ASAPCountByCellColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain cell color.
- New worksheet formula: =ASAPCountByFontColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain font color.
- New worksheet formula: =ASAPGetDomain(vFullURL, Optional bIncludeProtocol)
  Return the domainnaam from a given url.
  

---

ASAP Utilities 3.10E (October 16, 2006) for Excel 97

This version is compatible with Excel 97 and all future versions.
It does not require any special user-rights during the setup. If you
have Excel 2000 or newer and you do have administrator or power user
rights we recommend you to use the new version 4.0 also available from
our website. That new version has some great new and improved
utilities.

New features:

- ASAP Utilities now contains a digital signature.
  This gives several benefits. For one example, it assures you that the files
  come from us and have not been tampered with. The company name you will see
  on the certificate is "eGate Internet Solutions v.o.f.", which is the name
  of the company behind ASAP Utilities.
  http://www.asap-utilities.com/contact.php
  Description of Microsoft about digital signatures:
  http://office.microsoft.com/en-us/assistance/HA011403071033.aspx

Bug fixes:

- The ASAP Utilities menu was not properly removed when you closed Excel.
  This resulted, especially in Excel 97 in an ever increasing toolbar
  file (xlb). The .xlb file has all Toolbar customization in it. A toolbar
  file that is too large can cause problems in Excel and might cause a slow
  startup of Excel.
  A "normal" size is < 30 kb.
  The .xlb file has all Toolbar customization in it.
  If you believe Excel is not behaving the way it should, you can try the
  following:
  . Close Excel Do a search for .xlb in windows
  . Rename the file you find, e.g. rename the .xlb to .bac (my file is named
    Excel10.xlb in 2002, Excel11.xlb in 2003)
  . If you make your own toolbars or add buttons to the others this file is
    important (backup it so you can restore it)
  . Deleting the file or renaming will do no harm on your system, Excel will
    automaticly create a new one for you. (However you lost your customization
    remember that)
  . Start Excel
  

---

ASAP Utilities 3.10d (20 september 2006) for Excel 97

Bug fixes:

- System » Rename current file
  If you specified a filename of a file that already existed that file was
  overwritten. ASAP Utilities will now ask you if you want to overwrite the
  existing file.
- Objects/Comments » Delete all objects from current sheet
  Remove objects handles form/VBA buttons better.
- Fill » Fill 'between values' linear in selection (vertical).
  was swiched in the menu with the horizontal version.
  That is now corrected and horizontal fill now works too.
- Fill » Fill 'between values' linear in selection (vertical).
  was swiched in the menu with the horizontal version.
  That is now corrected and horizontal fill now works too.
- Fill » Copy values to empty cells below filled cells in selection
  Resulted in an error when your selection included a cell in row
  number 1 and that cell was empty. This is now fixed.
- Range » Paste Special (with combinations)...
  Operations (like multiply) now function too
- General
  When you close Excel, and then chose "No", the ASAP Utilities menu
  was removed. This is now fixed. The ASAP Utilities menu will only
  be removed if you really close down Excel.
- System » Rename current file...
  When you use this tool to rename a template file (xlt) the renamed file was
  opened as a workbook based on the template. This is now corrected. The renamed
  template will be opened for editing.
- Text » Delete leading and trailing spaces
  Fixed the bug that could incorrectly convert dates. These cells are
  now skipped.
- Text » Delete leading and trailing and excessive spaces
  Fixed the bug that could incorrectly convert dates. These cells are
  now skipped.
- Select » Expand selection to last row
  Now supports multiple selected areas
- Select » Expand selection to last column
  Now supports multiple selected areas
- Select » Inverse selection
  Produced an error if you cancelled the selection of a cell.
- Numbers » Use a significant number of decimals
  Gave an error when you used it on cells without decimals.
  The speed of this utility is increased too.
- System » Clear recent files list in file menu
  Used to reset the amount of recent files back to Excel's default which is 4.
  This is now fixed and your setting will be kept.
- Objects » Select all objects on current sheet
  Gave an error if the sheet contained comments. A workaround has been made to make
  it work in that occasion too.
  

---

ASAP Utilities 3.10c (26 januari 2006)

New features:

- Import » insert textfile seperated by !
  Import a textfile seperated by an exclamation mark (!)

Bug fixes:

- Improved range rebuild when you select entire columns

- Several minor bug fixes.

- Corrected some typing errors.

  

---

ASAP Utilities 3.10b (24 januari 2006)

This version is compatible with Excel 97 and all future
versions. It does not require any special (administrator)
rights. If you have Excel 2000 or newer and you do have
administrator rights we recommend you to use the new
version 3.11 also available from our website. That new
version is faster and has some nice additions, but it also
has a few more demands from your system.

New features:

- Range » Apply formula (improved)
  1. The last 100 used formulas are remembered so you can easily re-use them.
  2. Users of the non-English Excel versions can now type in the formula in
    their local language. For example in the Dutch version you used to have
    to use a point as decimal separator. You can now use the comma.
    You can also use the local version of worksheet formulas, for example if you
    have the Dutch version of Excel you can now enter '+SOM(G20:G40)' in stead
    of the English version: +SUM(G20:G40).
  3. We have improved the error handling. You get a warning if an applied
    formula produces an error.
  4. In the range of cells you select the formula will only be applied to
    cells that have no errors, are not empty and have a value of formula
    with a numeric or logical result (text cells will be skipped).
    Array formulas will also be skipped.
- New worksheet function: =ASAPGetHyperlink(range, optional sNA)
  This function returns the hyperlink from a cell. The hyperlink can be one of the following:
  . existing file or web page
  . place in your document
  . e-mail address
  You can optionally specify a string value for the sNA, this text will be displayed for
  cells without hyperlinks. If omitted the formula will give an empty result for cells
  without hyperlinks.
  Example: =ASAPGETHYPERLINK(A2,"-")
- Web » Clean web imported data...
  1. A new option is added: fix (text) numbers. Sometimes Excel doesn't recognize numbers
    properly and they are treated as text which often means they are left aligned and can't
    be used in calculations. This new option solves that.
    This new option does the same as ASAP Utilities » Numbers » Convert 'textnumbers' to
    numbers
  2. Another new option is added: unmerge cells. This unmerges all merged cells in your
    selection.
- I have changed the hotkey (accelerator) for the ASAP Utilities in the menu.
  By default this is the letter A (so you can access the ASAP Utilities menu
  with Alt+A.) However in some countries this conflicts with other menu items
  (such as Archivo, Data). Therefore, in the following countries the hotkey is
  the letter S:
  . The Netherlands (new)
  . Sweden (new)
  . Spain
  . Brazil
  . Portugal
- Format » Advanced Transposer... (improved)
  . formulas will be better preserved and cell-references in the formulas will
    be automaticly updates as the cells are transposed.
  . formatting of the cells will also be transposed.
  . the number of columns you enter is saved and used when you run the utility again.
  . the example is updated and improved.
  . the question remove completely empty rows is removed, the procedure is improved
    so that the data is transposed without creating empty rows.
  . we have built in a check to see if the amount of columns you enter will actually
    fit on the worksheet.
- Web » Clean Web Imported data...
  The layout is improved.
- Sheets » Protect all sheets
  The password is now by default masked.
  It also has the option to protect only selected or all sheets.
- Sheets » Unprotect all sheets
  The password is now by default masked.
  It also has the option to unprotect only selected or all sheets.
- Several small additions and improvements.

Bug fixes:

- Select » Select cells with maximum value.
  In some cases the cells with the maximum value were found but were not selected.
  This had something to do with the number of decimals the max value contained
  and the way they were displayed in Excel. E.g. a value of 21,723801267259 was
  displayed as 21,72380127 which didn't match when we used Excel's built in search
  function. We've changed the way of selecting the cell with the max value so it
  works in these occasions as well.
  It now also checks at the start if you selection contains numbers.
- Text » Convert to upper etc. keeps formulas, but converts them to uppercase
  (if you have text displayed). Is doesn't convert formula's to values anymore
- Text » Start first word with uppercase.
  Now also converts the rest of the text to lowercase so for example BASTIEN
  becomes Bastien
- Objects/Comments » Delete all objects from current sheet
  Remove objects handles form/VBA buttons better.
- Web » Clean web imported data...
  Remove objects handles form/VBA buttons better.
- Fill » Overwrite filled cells in selection.
  Did not work when you entered a zero (0). This is now corrected.
- Improved range rebuild when you select entire rows or columns where
  the first rows/columns are empty.
- Select » Conditional column and row select, hide, delete...
  Remove duplicates in column fixed
  Hide duplicates in column fixed
- Fill » Fill 'between values' linear in selection (horizontal)
  Didn't work, fixed it and is now working
- Range » Paste Special (with combinations)...
  Operations (like multiply) now function too
- Fill » Fill 'between values' linear in selection (vertical).
  was swiched in the menu with the horizontal version.
  That is now corrected and horizontal fill now works too.
- Several minor bug fixes.

- Corrected some typing errors.

  

---

ASAP Utilities 3.10 (28 june 2005)

New features:

- Select » Conditional select
  . number (constant), e.g. 12
  . number (formula), e.g. =12*2.20371
  . number (link to sheet), e.g. =sheet1!A1
  . number (link to file), e.g. ='[Test alignment.xls]Sheet1'!$A$1
- Range » Remove empty rows
  This could already be accomplished with the
  SELECT » Conditional row and column select, hide or
  delete function, but it is now available as a
  single utility.
- Columns/Rows » Color each n'th row or column.
  Now remembers your last used color.
- Columns/Rows » Merge column data (join cells)
  You can now specify how to handle empty cells.
  You can also specify if the cells have to be treated
  as formulas, values or formatted text.
  I've also added the option to merge with the tab-
  character of use a line-break.
- Text » Insert before/after
  Improved combined insert before and/or after
  An apostrophe can now also be inserted before.
  This can be handy when you want do display your
  formulas as text.
  You can also specify if the cells have to be treated
  as formulas, values or formatted text.
  You can exclude hidden cells. (comes in handy when
  you're working with filtered ranges).
- Fill » Quicknumber numbering of cells
  The cells were always aligned right.
  This is now optional.
- Format » Wrap text
  Wraps the text in selected cells, which makes long
  lines break into multiple lines.
- Format » Unwrap text
  Unwraps the text in selected cells.
- Web » Clean webimported data
  Added the option to remove all cell-borders.
- Web » Extract hyperlinks
  Extracts the hyperlink-address of the cell.
  This value can be placed in the cell itself or in the
  column next to it.
- Export » Export selection or active sheet a new file
  Export range as picture, the image size has been expanded
  from 800x600 px to a maximum of 5000x5000 px
- Several small additions.

Bug fixes:

- False Virus alert in sytem.asap - Gone ?
  Some virusscanners reported a virus in system.asap.
  Of course this was a false error, but it caused a lot
  of "stress". The reason was caused by the codeline:
  insertline() which was in the System » Macro/VBA
  information » Code washer part. Here you can choose
  to remove empty lines, commentlines and the indentation
  from your vba modules. Do do this we used the
  .insertline() command.
  Since this caused some virusscanners to panic, we've
  used another approach to accomplish the same result.
- Fixed problems that could occur when the location of
  the favorites menu could not be found or was not
  properly set.
- Selection
  Fixed an annoying bug that sometimes caused to
  change the selection of your cells. This could happen
  when you selected the entire sheet or entire columns
  or rows.
- System » Remove all macros/VBA from current file
  On some systems this produced a compile error. This
  is now solved (at least on my test-systems).
- Objects/Comments » Comment tools
  There was a bug in the "Create report in new file"
  feature as comments are reported (incorrect) multiple
  times: Comments of the first sheet were printed again as
  comments belonging to the second sheet if the second sheet
  does not contain any comments itself. The wrong duplicates
  were repeated until a sheet contained a comment again.
- Export » HTML export
  Fixed a combination that produced incorrect HTML tags
  (color outside <td> tag)
- Export » Export selection or active sheet a new file
  Fixed the bug that produced an error in Excel 2003
  "The command could not be completed by using the range
  specified. Select a single cell within the range and
  try the command again."
  

---

ASAP Utilities 3.09 (20 april 2005)

New features:

- Menu
  A few specific ASAP Utilities functions have been
  placed in the submenu ASAP.
- ASAP :: Find you utility (search help)
  Search through the entire menu and descriptions of all
  ASAP Utilities. If you don't enter a search phrase it
  will list all tools.
- Select :: Conditional select cells
  . select odd rows
  . select even rows
  . select where font is strikethrough
  . select visible cells
- Select :: Conditional row and column select, hide or delete
  . select odd rows
  . select even rows
- Range :: Find / Replace in all sheets
  Besides the normal text you can now also search and replace
  a few special characters:
  . line feed (alt+enter, chr(10)) -> use {lf}
  . carriage return, chr(13) -> use {cr}
  . horizontal tab, chr(9) -> use {t}
- Columns/rows :: Delete all hidden rows and columns
  Removes all hidden rows and columns on the active sheet.
  Useful when you want to pass to clean up the file before
  distributing and delete all unnecessary information.
  Be careful when you have formula's with references to
  data in the hidden cells.
- Export :: Export selection or activesheet as new file
  Added the option to directly export to clipboard in
  space-delimited format.
- Information :: File and selection info.
  Returned the information in A1-reference style.
  New is that it now looks at your settings. If you
  use the R1C1 reference style it will show it in
  that format.
- System :: Find and remove external links
  Search is now also performed in all rangenames.
  If you delete a range-name with an external reference
  and have used it on you sheet, the error value '#NAME'
  is displayed in the cell or cells that use the defined name.
- Web :: Optimize web import
  Has been renamed to Clean web import

Bug fixes:

- Spell check on the menu and tools description

- Numbers :: Convert formulas to their values
  a very very long lime when you selected then entire
  worksheet (A1:IV65536).
- System :: Find and remove external links
  Returned an error when you selection on a worksheet
  was not a range but e.g. a chart.
- Sheets :: Protect all sheets
  Returned an error when your workbook contained other
  sheets than just worksheets. Now you can also protect
  other sheet-types (like charts).
  Returned an error when you had a group of sheets
  selected.
- Range :: Find / Replace in all sheets
  Returned an error on hidden sheets. These sheets
  are now excluded from you search. A label shows
  you if there are hidden sheets.
- Fill :: Quick numbering of cells
  If your selection started on row nr 1 and you choose
  "restart numbering if the value in the column changes"
  the follwing error ocurred: "Application-defined or
  object-defined error.
  

---

ASAP Utilities 3.08 (14 october 2004)

New features:

- Range :: Find / replace in all sheets.
  Allows you to easily search in all worksheets at once.
  The results are presented in a list. When you click on
  a result you immediately will be taken to that value.
  Replacements can be done one by one or in all
  worksheets at once. The result box can be expanded,
  depending on your screensize.
- Numbers :: Numbers to words
  This function has been renamed and exanded. The new
  name is 'spell numbers or amounts (EN, NL, DE)'
  It spells out the numbers for you in English, Dutch
  or German. You can optionally choose to add a currency
  or type one yourself. The spelled numbers will always
  be rounded to two decimals.
- Objects :: new name : Objects/Comments
  Added several comment tools. You can now easily:
  . create a document with all information contained
    in the comment fields. (sheetname - cell address -
    name - value - author - comment)
  . place the value of the comment in the next right
    column
  . move all comments to their default position
  . resize all comments to fit their content
  . change the font name and size in all comments.
  . replace text in comment fields.
- Custom functions
  Added a new function which allows you to read
  the content of a cells comment.
  =ASAPGetComment(reference), i.g. =ASAPGetComment(B12)
- Custom functions
  Added a new function that allows you to retreive
  the colornumber of a cell. This can be of use when
  you want to sort cells by their color.
  =ASAPCellColorIndex(reference), i.g. =ASAPCellColorIndex(B12)
- System :: Find and remove external links
  When you have links in your file to other workbooks,
  Excel asks you whether you want to update your links
  or not. Sometimes you want to get rid of these links,
  but that is not always easy. This new tool searches
  your entire workbook for external links, presents
  them to you one by one and askes if you want to remove
  the link. The value in the cells with external links
  will be replaced by the actual value in stead of the
  link.
- System :: Close all files except the current one
  Shows all open files in a list which allows you
  to quickly close all unnecessary files.
  Has a (default) option to notify to save before
  closing non-saved files.
- Favorites menu
  Added an option to reset to default settings.
  These are the tools that used to have built-in
  shortcut-keys. Now immediately rebuilds the menu
  when loaded.
- Columns / Rows :: "Merge columns"
  Now supports multiple selection areas
- Export :: HTML export
  Improved layout with all the settings in one view.
  Added the option to specify a <td class="">.
  The generated code can now, besides your browser,
  also easily be opened with Notepad.
  You can specify whether you want blank cells to
  be left empty or to be filled with a &nbsp;

Bug fixes:

- Favorites menu
  Error in Favorites menu in Excel 2003 fixed.
- Menu
  Error in menu-creation fixed when the menubar
  was protected. In this case the protection will
  temporary be removed, the ASAP Utilities menu will be
  created and then the menubar will be protected again.
  (Error # -2147467259 Method 'Add' of object
  'CommandBarControls' failed)
- Range - Copy formulas without changing their references,
  fixed the error in Excel 2000.
- Sheets :: Show all sheets
  Fixed the error when your workbook contained charts
  or a MS Excel 5.0 Dailog.
- Export :: export as CSV file
  Now correctly handles whether you want to export
  hidden cells or not. The previous version never
  exported hidden cells.
- Text :: Convert dates
  An error occurred when trying to convert ancient
  date, i.g. 01-12-1753. The date-converter now
  checks for valid dates, since Excel doesn't recognize
  dates before 01-01-1900.
  

---

ASAP Utilities 3.07b (7 may 2004)

New features:

- Text - Remove ending carriage returns (alt+enter)

- Options - Dialog expanded with "contact information".
  If you encounter problems and need to contact us,
  please provide the information in this dialog. It will
  tell us information about your operating system and
  excel version, language settings and the installation
  path of ASAP Utilities.
- Favorites menu - option to reset to default settings.
  These are the tools that used to have built-in
  shortcut-keys.

Bug fixes:

- Compile errors in hidden modules in Excel 97 fixed.

 

---

ASAP Utilities 3.07 (20 april 2004)

New features:

- Export - Export selection or sheet as new file
  CSV Export, conform according to the international
  standard or with you own specifications.
- Menu, New in the Portuguese and Brazilian version of
  Excel, the shortcut for the ASAP Utilities menu will
  be changed from A (also Archivo) to S.
- Menu - improved error handler with better description
  that will help to solve possible problems.
- Menu - shortcuts can you all be assigned by yourself
  in the favorites menu. All existing built-in shortcuts
  have been removed. By default if not already exists
  a personal favorites menu will be installed with all
  the previous shortcuts. Instead of the Ctrl+Shift
  combination they are now a Ctrl+Alt combination
- Text - Advanced character removal. Advanced utility
  that gives you control on any character, including
  invisible ones like linefeeds(enter).
- System - Macro/VBA information. This utilties has the
  capability of deleting your code procedure by procedure.
  It also contains an option to export your VBA code.
  Will we expanded in future versions.

Bug fixes:

- Favorites menu, fixed the bug when you tried to change
  the location of the personal menu file.
- Fixed the bug that caused the search and replace box to
  be filled after the startup of ASAP Utilities.
- Text - convert dates. Fixed the error when your selection
  contained empty cells.
- Apply formula : turned off the screenupdating.

- Handle lowercase/uppercase. Doesn't generate an error
  anymore if your selection contains empty cells.
- Range - Copy formulas without changing their references,
  fixed the problems causing it not to work properly in
  Excel 2002/XP.
- System - Remove all macro's from current file. Fixed the
  XL2002: Error Message: Run-Time Error '1004'.
- During the startup ASAP Utilities will now check if all
  additional required files are available (the .asap files)

---

ASAP Utilities 3.06 (23 september 2003)

New features:

- Favorites
  Create a submenu with your favorite tools. You can also
  assign your own shortcuts.
- Range
  Paste both values and formatting at the same time.
- Sheets
  add sheets with the names defined in selected cells. Now
  has the possibility to use a "template" sheet.
- Object
  Show the flowchart and connecter commandbars. This works
  faster when you have to create a flowchart.
- Range
   Conditional select now also selects odd or even numbers.

Bug fixes:

- XL2002: Error Message: Run-Time Error '1004': Programmatic
  Access to the Visual Basic Project Is Not Trusted
  This happens when ASAP Utilities tries to access your vbProject.
  (see also:
  http://support.microsoft.com/default.aspx?scid=kb;en-us;282033)
- sheet-index generator, chart indexes

- convert dates (i.e. with spaces as seperator)

- Link to the website when a new version is available.

- The trim function now also handles "internet spaces", chr(160)
  correct.
- Fill empty cells in selection. Handles it correctly when
  you want to enter a zero in alle empty cells.

---

ASAP Utilities 3.05 (12 januari 2003)

New features:

- Sheets
  Summarize sheets. Is now possible to create a dynamic
  consolidation of rows/columns on various sheets.

Bug fix:

- Fixed the compile error in Excel 97 for a few
  functions (remove all macro's, optimize webimport..)

---

ASAP Utilities 3.04 (9 januari 2003)

New features:

- Select
  Move selection. Easily move your selection to left,
  right, up or down, using alt+l, alt+r, alt+u or alt+d
- Range
  Conditional select. Select cells with a certain length
  (i.g. 8 characters long)
- Range
  Pastespecial, with multiple options. I.e. paste both
  values and formatting.
- Web
  Optimize webimport. Easily clean a tabled copied
  from the intenet into Excel. I.e. remove hyperlinks,
  font colors, etc.
- Information
  Fast Calculation, smoothened and expanded.
  Count unique values added. Option added to copy the
  information to a new workbook.
- System
  Rename file. The renamed file is added to the recent-
  files list.
  Rename file. The utility asks for a new filename in the
  folder where the file is currently saved.

Bug fix:

- Text
  Convert Dates, fixed buffer overflow, for example with
  a date like 20020508
- Fill
  Insert before and Insert after. Fixed the error when
  your selection contained formula's with errors. Now
  these cells will be skipped and the operation continues.
- Numbers
  Convert formulas to their values. In some cases a pop-up
  appeared that workbook ??? could not be found. This
  is now solved.
- Menu
  Fixed the bug that appeared on some system (compile error
  in hidden module menu).

---

ASAP Utilities 3.03 (2 juli 2002)

New features:

- Text
  Date converter. This will convert a text-string-date
  to another formatted date. I.e. 010101 becomes
  1 january 2001, or 2001-12-02 becomes 12 feb 2001.
  The conversion is very flexible.
- Undo
  I've built an undo option in a few functions.
  In time more most function will get an undo.
- Select
  Conditional select, added options to select cells that
  are NOT bold, underlined or italic.
- Range
  Randomize list, by row. Easily randomize the order
  your list is shown.
- Sheets
  Add sheet (inputbox will appear for the name)
  If you enter a name that exceeds 31 characters ASAP
  will automaticly reduce it to 31 characters.
- Custom formulas
  ASAPCountShades() : Counts the number of cells that
         are colored within the given range.
  ASAPSumByFontColor() : Sums the cells with a given color
         in a given range. The color is Excels
         colorindex (1-56).
  ASAPFontColorIndex() : Returns the fonts colorindex
         number (1-56).
  ASAPFullFilename() : Returns the full path and filename
         of the active workbook
  ASAPFileName() : Returns the filename of the active workbook
  ASAPFilePath() ; Returns the path of the active workbook

Bug fix:

- Select
  Conditional select. Fixed the bug when trying to select
  text that was "not like"
- Import
  Merge files together in a new file. The ability to
  import each file on a new sheet is now available.
- HTML export
  removed double ">>" when exporting without a font
  attribute.
- Range
  Hide errors updated, will now work with in all
  languages.
- Text
  Make last character super- or subscript will no longer
  give you an error message if there is a numeric cell
  in the target selection.
- Quicknumber
  Fixed the error when the leading zero's was less then
  the number-length. (i.e. 2 leading zero's on 100).
- Update info
  Fixed the "error 13" on Excel 97 machines, when the update
  information appears. I've also added an option not to hide
  the update-reminder for a period of 10 days.

---

ASAP Utilities 3.02 (31 JANUARY 2002)

New features:

- Conditional select.
  Select text and choose whether to match case or not.
  Did you know you can already use wildcards (*) in your
  search string?
- Export
  New option let's you choose not to include hidden cells
  in your export
- Apply Formula
  formula's will be preserved
- Conditional Select
  select text and choose whether to match case or not.
- Import
  Merge files. Easily combine multiple file into one
  file.
- Range
  Hide or replace formula errors. In stead of having a
  formula error displayed as #N/A you can now easily
  use this utility to display a custom error-messages.
- Color Rows and Columns
  when asked to continue, the cancel option now works.
- HTML export.
  Hidden cells will now be excluded from the generated
  html-table

Bug fix:

- Faster start of ASAP Utilities

- Close ASAP Utilities
  all submodules will first be closed and after that
  ASAP Utilities will be closed without errors
- System
  Remove all VBA from current workbook now checks to
  see if the vba project is not protected.
- HTML export.
  The font tag will now be closed (</font>).
- Menu.
  The Chart menu will now have only the options available
  that apply to charts or general functions.
- Menu
  In the spanish version of Excel, the shortcut for the
  ASAP Utilities menu will be changed from A (also Archivo)
  to S.