What's new on ASAP Utilities

We'll keep you updated about new releases of ASAP Utilities. If you want to receive an email as soon as a new version is released, then subscribe to our newsletter. The news is also available as an rss-feed

Dagens nettjuvel: Gratis forbedring av Excel

Av Einar Ryvarden - Oslo - Her er et omfattende gratis-tillegg til Microsoft Excel som gir deg 300 nye funksjoner og muligheter.

ASAP Utilities er et tillegg til Excel 97, 2000 og XP som gir deg en lang rekke nyttig funksjoner og muligheter. Et eksempel er ? kunne velge alle celler med bestemte verdier (fks. st?rre enn 12) eller som har r?de tekst eller bakgrunn.

http://www.digi.no/php/art.php?id=67292&f=katnav

ASAP Utilities 3.03 is now available for download.

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.

News on ASAP Utilities 3.03

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	We've built an undo option in a few functions. In time more most function will get an undo.
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.

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.
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).

ASAP Utilities 3.02 is released!

I would like to thank all the people that have been sending me their comments and suggestions. Unfortunately due to the large amount of email I'm no longer capable of answering everybody. However we collect all your suggestions and implement most of them in (future versions of) ASAP Utilities.
Thank you all for the great ideas (and patience too) !

New or improved functions:
Read the rest of this story »

Lockergnone: 'You'll wonder how you lived in Excel without it, I swear!'

In october 2001 Lockergnome, a big free technology e-mail newsletter, wrote a review about ASAP Utilities in their newsletter and on their website:

'Many of you liked the ASAP Utilities for Excel featured some time back in the Tech Specialist, so when the author mentioned his new version was available, I figured you'd want to know. The gaggle of tools included most definitely make Excel easier to use all the way around. It simplifies some rather complex tasks into short operations, saving you plenty of time better suited to hanging out eating bagels with your co-workers. You'll wonder how you lived in Excel without it, I swear!'

http://channels.lockergnome.com/it/backissues/20011001.phtml

« previous 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 next »

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

Empowering Excel Users Worldwide for 25 Years