ASAP Utilities

[indeec]

ASAP Utilities 4.2.9

Вышла новая версия ASAP Utilities - мощной надстройки для электронных таблиц Microsoft Excel, предназначенной для облегчения работы с программой и автоматизации рутинных, часто повторяемых действий...


ASAP Utilities может выполнять более трехсот функций. При некоммерческом использовании программа полностью бесплатна.

Для работы необходим MS Excel 2000/2002/XP/2003/2007.

описание, на заморском языке:

ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel and automates frequently used tasks. Since 1999 it has grown to become probably one of the world's most popular add-ins for MS Excel.

A few of ASAP Utilities' popular macro tools that will speed up your work in Excel:
Deselect cells in your selection | video
Apply formula to selected cells | video
Conditional select cells: for example select cells greater than 12 or all red cells
Advanced sorting: for example sort by color | video
Copy a worksheet's page and print settings
Vision control: view workbooks, sheets and easily change their settings
Print multiple sheets
Color each n'th row or column in selection (color banding)
File import and export (txt, csv, dbf, xls, gif, jpg, etc.)
Export selection as HTML table (including formats, colors etc.)
Assign your own shortcuts to the utilities you use the most
More: list of all utilities and extra worksheet functions

ASAP Utilities installs and upgrades easily and creates its own submenu in Excel next to the help-button. If you use ASAP Utilities in a commercial organization you are allowed to try it for 90 days. If you like it and continue to use it, simply purchase a license key.

What's New:

New
Text » Replace accented characters (á, ë, ñ etc.)... The following characters have been added: ă, ǻ, ĕ, ї, ĩ, ĭ

Bugs fixed
Fill » Insert after current value... Didn't work if you had a numeric cell and only choose to add something after the value is each cell. This bug was introduced in version 4.2.8 and is now fixed.
Fill » Insert current date and time with seconds. Gave an error when the formatting of the sheet was protected. This is now fixed, in that case only the date and time will be entered in the cell and the cell formatting will not be changed.
Fill » Insert current time with seconds. Gave an error when the formatting of the sheet was protected. This is now fixed, in that case only the date and time will be entered in the cell and the cell formatting will not be changed.
Export » Export selection or active sheet as new file... Fixed the error at line 1350 that a sheet couldn't be renamed in certain situations.
Range » Advanced sorting... In certain situations you could get an error when you started the utility after having used it before in the same Excel session. This is now fixed.

[Для просмотра данной ссылки нужно зарегистрироваться]