ASAP Utilities - ASAP Utilities Blog - Page 9

New version: 21 june 2006

Jun 21, 2006 Bastien 2 Comment

A new beta version of ASAP Utilities is available: 3.11.aa beta (21 june 2006). Last week version 3.11.z was silently released. I updated the download page but couldn't find the time to write a post about it. So here are the major changes in comparison to version 3.11.y in the new 3.11.aa. These are the major changes: Sheets » ...

Comments are open again

Jun 5, 2006 Bastien 0 Comment

I'm back from a few days of mountainbiking in the Dutch Mountains (hills...). Comments are no longer held for moderation, unless the spam filter holds them. The past days 184 spam-comments have been placed. If I have some spare hours I will update the comment-module with better spam-protection. WordPress already has some nice tools: codex.wordpress.org/Combating_Comment_Spam. Tommorrow I'm ...

Comments held for moderation

Jun 2, 2006 Bastien 0 Comment

The ASAP Utilties blog is getting a lot of comment-spam. The next couple of days I will not be able to remove the comments that slip through the spam filter. Therefore all comments the next days are held for moderation. If you place a comment, pleace take notice that it will take a few days ...

New version: 30 may 2006

May 30, 2006 Bastien 3 Comment

Text » Replace accented vowels

A new beta version of ASAP Utilities is available: 3.11.y beta (30 may 2006). These are the major changes: Change decimals (not formatting, but changing) has been renamed to Round numbers (not formatting, but changing) HTML export <strike> is added for text that is formatted as strikethrough. Range » Empty duplicates on selection. Now works on multiple columns. Cells ...

Favorite project

May 19, 2006 Bastien 5 Comment

After spending many weeks programming in PHP/MySQL for two projects with a very tight deadline and some small Excel projects, I've found the time to work on my favorite project again. I'm working my way through all the comments and recommendations I received the past month. Some of them are bug reports, spelling corrections, tips ...

New version: 6 april 2006

Apr 6, 2006 Bastien 9 Comment

A new beta version of ASAP Utilities is available: 3.11.x beta (6 april 2006). In this version a bug in the protect all sheets has been fixed regarding the option to enable/disable the selection of unlocked cells. Furthermore the following is changed/added: Text » Advanced character removal Besides removing the characters you can now also have them ...

New version: 4 april 2006

Apr 4, 2006 Bastien 5 Comment

protection: enable the selection of (un)locked cells

A new beta version of ASAP Utilities is available: 3.11.w beta (4 april 2006). In this version a few bugs in the protect/unprotect all sheets have been fixed. Furthermore the protection in Excel XP/2002/2003 that enables you to select (un)locked cells (or not) has now been implemented too.

Toggle fullscreen with F11

Apr 3, 2006 Bastien 0 Comment

This evening I needed to create a flowchart. Excel is my favorite application to do this. However the screenresolution on my notebook is a bit less then my computer at work, so I wondered how I could view my information better. Of course you can set the zoom to less then 100% but then I ...

New version: 3 april 2006

Apr 3, 2006 Bastien 0 Comment

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

From beta to final version?

Mar 30, 2006 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 ...

New progress indicators

Mar 28, 2006 Bastien 1 Comment

old progress indicator

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

ASAP Utilities 3.11 beta 28 march released

Mar 28, 2006 Bastien 73 Comment

advanced sorting

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

Overwhelming

Jan 26, 2006 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...

ASAP Utilities 3.10b released today

Jan 24, 2006 Bastien 3 Comment

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

Practice makes perfect

Jan 20, 2006 Bastien 0 Comment

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.

Happy New Year!

Jan 1, 2006 Bastien 0 Comment

I wish you all a happy new year with lots of health, happyness and prosperity.

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!

How to copy addresses from Excel to your new years email-message

Jan 1, 2006 Bastien 0 Comment

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

Productivity Portfolio: ASAP Utilities Provides Excel Users Power and Flexibility

Dec 21, 2005 Bastien 0 Comment

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

Create multiple worksheet copies

Dec 1, 2005 Bastien 13 Comment

Just got a question from Denice, US: Is there a way ASAP can take one worksheet and make multiple copies of it. I formatted one sheet and would like to make a lot of copies at once without doing the right click add or make copy. Does it already do this and I missed it. Or ...

Insert empty rows between groups

Nov 18, 2005 Bastien 0 Comment

If you have columns with large amounts of repeating values sometimes it is easy to distinguish them be seperating them with a line or empty row. Last week Peter asked me: I just found your utility download for excel on the web. It is great. I'm trying to combine a couple of the utilities into ...

ASAP Utilities and the Apple Macintosh or OpenOffice

Nov 18, 2005 Bastien 2 Comment

Lately I recieve a lot of email from people asking me if there is a Mac version of ASAP Utilities. Currently ASAP Utilities will only work on Windows Excel versions. Excel for Windows and Excel for Mac differ a bit. My apologies, perhaps in the future when I have a Mac myself and know how that works, I ...

ASAP Utilities General

Conditional row color based on a cell value

Nov 7, 2005 Bastien 109 Comment

Jeremy (US) asked me a question about coloring based on a cells value: First your product ASAP Utilities is great and has been a life saver. One feature that would be outstanding is a conditional row color based on a cell value. For instance there are numerous times I have to color a row because the value ...

ASAP Utilities General

Create a colorindex table

Oct 19, 2005 Bastien 3 Comment

I'm working on an ASAP Utilities User Guide. When describing some of the worksheet function that use the colorindex property, I needed a good example of all available colors. So I wrote a quick macro to create a colorindex-table but enhanced it to show the colors in the same order as it is shown in ...

How to merge rows

Oct 14, 2005 Bastien 3 Comment

Last week Hugo (California) asked me to create a new tool in ASAP Utilities to create what he calls a "tickerstring". This way multiple rows in a column will be merged into the first row. But you know what? It's already available: Select the range, then in the menu select ASAP Utilities > Columns/rows > Merge row ...

Hide formula errors like N/A or #VALUE!

Oct 7, 2005 Bastien 5 Comment

A question I received today from Daniel (Mexico City) : I will like to suggest you the possibility of including in the formula menu a funtion like "Hide Formula Errors" to stop the anoing NA or VALUE? Thanks for making this kind's of tools for excel, from now on hopefully I will spend less time in making ...