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

New version: 21 june 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 » ...
ASAP Utilities

Comments are open again

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

Comments held for moderation

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

New version: 30 may 2006

Bastien 3 Comment
Text » Replace accented vowelsA 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 ...
ASAP Utilities

Favorite project

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

New version: 6 april 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 ...
ASAP Utilities

New version: 4 april 2006

Bastien 5 Comment
protection: enable the selection of (un)locked cellsA 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.
ASAP Utilities

Toggle fullscreen with F11

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

ASAP Utilities

New version: 3 april 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 ...
ASAP Utilities

From beta to final version?

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

New progress indicators

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

ASAP Utilities 3.11 beta 28 march released

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

ASAP Utilities

Overwhelming

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

ASAP Utilities 3.10b released today

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

Functions General

Round up formulas with =ROUND()

Bastien 2 Comment
I just got a call from a friend of mine. He needed to edit a spreadsheet and round a bunch of formulas. Since the rounding is important for the calculations, a simple cell-formatting wouldn't do. Excel's worksheet function =ROUND() can be used to round the numbers. However editing a lot of cells by hand (especially with ...
General

So much spam these days

Bastien 4 Comment
It has been on of those 'spam-periods' again. My inbox this morning: Fortunately most spam is detected and all virussus are removed, but still a lot of rubbish comes through the filters. I use Outlook 2003 and I have also tried Thunderbird (Mozilla) but still too much spam comes through in both mail clients. My list of ...
ASAP Utilities

Insert empty rows between groups

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