Filed under: ASAP Utilities on April 3rd, 2006 by Bastien | Comments Off
A new beta version of ASAP Utilities is avialable:
3.11.v beta (3 april 2006).
In this version the HTML export is improved. The generated HTML code is better and the speed of the utility is much faster now, especially when you export a table with more than 500 individual cells. This is because we used to put the generated code in memory and in stead of that we now use a temporary file to build the code, and when that is finished, we load the file in one step into the memory and put it on your clipboard. On my computer a table with 14.000 cells now took 20 seconds to generate in stead of over 3 minutes.
The generated code is improved in some points. Empty </font> tags should now be gone and the order of the attributes (bold/italic/underlined) is improved, meaning that are closed in the reverse order from how they started. For example a cell that was
both bold and italic use to be in HTML <b><i>content</b></i> this is now <b><i>content</i></b>
Another improvement is the nowrap: nobr. This prevents word-wrapping a cell's content. This code used to be <nobr>content</nobr> in each cell. This is now replace by a CSS attribute on each row.
The past few days I received two bugs. After both the "Advanced Transposer..." and the "Export selection or sheet as new file..." utilities had run and you pressed the close button you recieved an error. These bugs are fixed in this new version.
Filed under: ASAP Utilities on April 3rd, 2006 by Bastien | Comments Off
Filed under: ASAP Utilities on March 30th, 2006 by Bastien | 1 Comment »
Today I have released a new beta version, 3.11.u (30 march 2006). The major change here is the new improved progress indicators. Furthermore I have fixed a bug in the "Unprotect sheets" functions. (popup for password if it didn't match).
Please let me know if you think this version good enhough to become the official new version.
Filed under: ASAP Utilities on March 30th, 2006 by Bastien | 1 Comment »
Filed under: ASAP Utilities on March 28th, 2006 by Bastien | 1 Comment »
Something that has bothered me a long time is the way the progress of the utilities in ASAP Utilities is indicated.
In most cases I used the statusbar to do this but I found out not everybody always sees that. In the
new beta version I published today (3.11.t beta) I have used a new progress indicator for a large part of the utilities. This also has the benefit that you can easily cancel an operation, for example if you have made a mistake and waiting for it to finish takes too long.
Read more...
Filed under: ASAP Utilities on March 28th, 2006 by Bastien | 1 Comment »
Filed under: ASAP Utilities on March 28th, 2006 by Bastien | 73 Comments »
Today I have released version 3.11.t beta 28 march 2006.
This new version contains some bugfixed (Export sheets as separate files in Excel 2000) and has an improved progress indicator. Furthermore the advanced sorting capabilities have been expanded. You can now sort dates directly by:
. Year-Month-Day
. Year-Day-Month
. Month-Day-Year
. Month-Year-Day
. Day-Year-Month
. Day-Month-Year
I have also found out that the way I was using this blog for the information on the new beta version wasn't used right. Therefore I have created a 'permanent' page with information on the new version.
I will post the new details in posts like this one and then refer to that page.
http://www.asap-utilities.com/blog/index.php/beta/
Read more...
Filed under: ASAP Utilities on March 28th, 2006 by Bastien | 73 Comments »
Filed under: ASAP Utilities on January 26th, 2006 by Bastien | 1 Comment »
I have received an enormous amount of emails with comments, suggestions and big thank-you's. A new version is always a good moment of people for contacting me.
This morning I published version 3.10c. I'm also nearly finished with a new beta 3.11. Stay tuned...
Filed under: ASAP Utilities on January 26th, 2006 by Bastien | 1 Comment »
Filed under: ASAP Utilities on January 24th, 2006 by Bastien | 3 Comments »
Update: version 3.10c is released, I changed the download link in this post.
ASAP Utilities released its new version (3.10b) today!
We make you the company's excel guru!
ASAP Utilities is a free and easy to use Add-In for MS Excel 97, 2000, 2002, XP and 2003. The utility contains over 300 functions to make your work easier and faster done.
Read more...
Filed under: ASAP Utilities on January 24th, 2006 by Bastien | 3 Comments »
Filed under: ASAP Utilities on January 20th, 2006 by Bastien | Comments Off
A lot op people are currently testing the new beta version and are giving me some good feedback. An updated beta version will be posted here this weekend.
Filed under: ASAP Utilities on January 20th, 2006 by Bastien | Comments Off
Filed under: ASAP Utilities on January 1st, 2006 by Bastien | Comments Off
I wish you all a wonderfull new year with lots of health, happyness and prosperity!

We've planned several new exiting tools and improved functions to ASAP Utilities in 2006. A new version will be released in a few weeks!
Filed under: ASAP Utilities on January 1st, 2006 by Bastien | Comments Off
Filed under: ASAP Utilities on January 1st, 2006 by Bastien | 2 Comments »
Yesterday a friend of mine called. He had a list of contacts he kept in Excel and he wanted to send out a new years letter to all of them. He knew he needed to use the BCC field to do this (to hide everyone's address for the others) but he didn't know an easy way to copy a bunch of email addresses from Excel into the BCC field of his email message.
In the following examples I'll show you how to get your email-addresses ready to copy into your email program.
Read more...
Filed under: ASAP Utilities on January 1st, 2006 by Bastien | 2 Comments »
Filed under: ASAP Utilities on December 21st, 2005 by Bastien | Comments Off
I'm proud to mention ASAP Utilities has been reviewed by Productivity Portfolio. A website about productivity and how to use certain tools.
ASAP Utilities Provides Excel Users Power and Flexibility
Excel is one of the pillars of Microsoft Office. Despite being feature-rich, there are some tasks that are either cumbersome to perform or are buried in the program. That shouldn't stop you from using Excel, as there are some third party tools that nicely complement the program. One example is the free add-in from Bastien Mensink called ASAP Utilities that provides easy access to over 300 utilities.
The problem with reviewing an add-in such as ASAP utilities is time. If you look at the website, you see the product has steadily added utilities since the product's inception in 1999. The total is now over 300. Just so we're clear, I didn't test all 300 of these. I didn't need to test all these utilities to make my decision. I knew after using just three. Whether you use Excel daily or infrequently, there are features in this package you can benefit from 'As Soon As Possible'.
Read more...
Filed under: ASAP Utilities on December 21st, 2005 by Bastien | Comments Off