ASAP Utilities 3.03 is now available for download.

Date: July 3, 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. When it comes to importing data from i.e. financial systems, this feature is extremely usefull. Whether the original date is like "mmddyy" or "ddmmyy" this utility will recognize and convert it! The conversion is very flexible.
Undo	I've built an undo option in a few functions. In time most functions 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 fixes:
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.
Select	Conditional select. Fixed the bug when trying to select text that was "not like"
Range	Custom formula error message (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.

« back

©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 25 Years