ASAP Utilities General

Fix the slow startup of Excel 2007

Bastien 61 Comment
Excel 2007 Splash Screen

Recently I have been receiving a few emails about people telling me that their Excel 2007 would startup very slowly with ASAP Utilities installed. The delay also occurred without ASAP Utilities if they click on an Excel file from within the Explorer: If I click on an xls file Excel opens with a blank window which delays... If ...

ASAP Utilities

New version in progress – pre-release 2

Bastien 0 Comment
New: User Guide in the ASAP Utilities menuI have just released a second preview-version of the new version of ASAP Utilities. This version solves a few more bugs. Furthermore the User Guide is now included in the setup and accessible from within the ASAP Utilities menu. I hope this way more people will be aware of the User Guide and spend some time reading it to ...
ASAP Utilities

New version in progress – pre-release

Bastien 2 Comment
Development in progressI have just released a preview-version of the new version of ASAP Utilities. This version solves nearly all the bugs that have been reported so far. Furthermore some utilities we added or improved. This new version will probably officially be released as a new version at the beginning of July. More information and download: //www.asap-utilities.com/faq-questions-answers-detail.php?m=149 At this moment the ...
ASAP Utilities

Information about array formulas in Excel

Bastien 0 Comment
Array formulas can help you in Excel to perform complex calculations, expecially if you want to do calculations with certain or multiple criteria. Here are a few links that provice more information and examples on how to use them: http://www.cpearson.com/excel/array.htm http://www.mrexcel.com/tip011.shtml http://office.microsoft.com/en-us/excel/HA010872901033.aspx http://www.pcmag.com/article2/0,4149,1265433,00.asp http://www.exceltip.com/exceltips.php?view=category&ID=106 http://tech.yahoo.com/gd/building-an-array-formula-in-excel/153304 http://support.microsoft.com/kb/275165 http://www.bettersolutions.com/excel/EDK153/LT423111411.htm
ASAP Utilities

New version in progress: January 8, 2007

Bastien 11 Comment
I'm working on a new version of ASAP Utilities that fixes a couple of bugs and has a few new features. Please tell me what you think of it. Download: ASAPUtilities_setup_4-0-6-RC1.exe New Export » Export selection as HTML table to clipboard... Added the option to specify an class for the TR-tag. You can also specify alternate use of the class. Range ...
ASAP Utilities

ASAP Utilities newsletter

Bastien 4 Comment
Last week I have sent out the ASAP Utilities newletter with information about the two new versions: ASAP Utilities released its new versions 4.0.5 and 3.10E! www.asap-utilities.com/asap-utilities-newsletter-2006-11.php More information about our mailinglist: www.asap-utilities.com/asap-utilities-mailinglist.php
ASAP Utilities

New version in progress: November 3, 2006

Bastien 3 Comment
The new version is completed for about 99%. The RC in the version stands for Release Candidate. I would like to thank everybody that emailed me the past couple of weeks! You can download 4.0.5 RC4, November 3, 2006: ASAPUtilities_setup_4-0-5-RC4.exe (1.1 MB) Major reason for this release are a few bugfixes. I will release this version officially probably ...
ASAP Utilities

New version in progress: October 17, 2006

Bastien 1 Comment

The new version of ASAP Utilities is still in progress. A few things took more time than I expected and I took the opportunity to add a few worksheet functions and a new utility. You can download 4.0.5 RC3, October 17, 2006: ASAPUtilities_setup_4-0-5-RC3.exe (1.1 MB) Please read the updated post from November 3, 2006 Major reason for this release ...

ASAP Utilities

New version in progress: October 6, 2006

Bastien 0 Comment

A new version of ASAP Utilities is in progress. You can download 4.0.5 RC2, October 6, 2006: ASAPUtilities_setup_4-0-5-RC2.exe (1.1 MB) Please read the updated post from October 17, 2006 Major reason for this release are a few bugfixes. Depending on the feedback I will release this version officially within a couple of days. I have also code-signed this version of ASAP ...

ASAP Utilities

New version in progress: October 4, 2006

Bastien 0 Comment

A new version of ASAP Utilities is in progress. You can download 4.0.5 RC1, October 4, 2006: ASAPUtilities_setup_4-0-5-RC1.exe (1.1 MB) Please read the updated post from October 6, 2006 Major reason for this release are a few bugfixes. Depending on the feedback I will release this version officially within a couple of days. Improved General Excel XP/2002/2003: Improved information on how to ...

ASAP Utilities

New version: September 20, 2006

Bastien 5 Comment
A new version of ASAP Utilities is just released. You can download 4.0.4, September 20, 2006 from the main website: www.asap-utilities.com/download-asap-utilities.php Major reason for this release are a few bugfixes. Thank you all for the feedback on the preview version. Improved utilities Delete leading and trailing spaces Cells with (array)formulas and errors will be skipped. Delete leading, trailing and excessive spaces Cells ...
ASAP Utilities

New version in progress: September 19, 2006

Bastien 0 Comment

A new version of ASAP Utilities is in progress. You can download 4.0.4 preview, September 19, 2006: ASAPUtilities_setup_4-0-4-preview.exe (1.1 MB) Depending on the feedback I will release this version officially withing a couple of days. Major reason for this release are a few bugfixes. Improved Delete leading and trailing spaces Cells with (array)formulas and errors will be skipped. Delete leading, ...

ASAP Utilities

New version: August 29, 2006

Bastien 13 Comment
A new version of ASAP Utilities is available: 4.0.3 (August 29, 2006). Major reason for this release are a few bugfixes, two new worksheet functions and an expanded description of the utilities. New worksheet function: =ASAPExtractNumbers(ref) This function extracts the numbers from a given range or value. New worksheet function: =ASAPStripNumbers(ref) This function strips the numbers ...
ASAP Utilities

New version: 3 august 2006

Bastien 5 Comment
list filenamesA new version of ASAP Utilities is available: 4.0.2 (3 august 2006). Major reason for this release is an added funtionality to the "Insert filename..." utility, overall accelerator keys (hotkeys) in the menu and a few bugfixes. Fill » List filename... When creating a list of all filenames in a folder you can now choose whether you ...
ASAP Utilities

New version: 31 july 2006

Bastien 3 Comment
A new version of ASAP Utilities is available: 4.0.1 (31 july 2006). I have also updated the User Guide. Major reason for this release is a few bugfixes. New worksheet formula: =ASAPSheetName() Returns the name of the sheet the formula is placed on. System » Rename current file If you specified a filename of a ...
ASAP Utilities

New version: 22 june 2006

Bastien 5 Comment
A new beta version of ASAP Utilities is available: 3.11.ab beta (22 june 2006). Major reason for this release were problems in combination with Excel 2000. The merge files or import Excel file made Excel 2000 produce errors or crash. I have created a workaround for this. (the command workbooks.open makes Excel 2000 crash if it is ...