Soon to be released: version 4.2.8

asap-utilities-428-repeat-action.png

While I'm working on the next big updated version (4.3), a few people have found some bugs in version 4.2.6 and 4.2.7 that I've now fixed in version 4.2.8. More information and download of the pre-release: http://www.asap-utilities.com/faq-questions-answers-detail.php?m=193 Version 4.2.7 was released on September 3rd. However a newsletter hasn't been sent out yet. I plan on doing this this ...

Replace formulas with their calculated results in multiple sheets

It's time to update this blog more often. I will do this by writing about questions I answered by email and that might be interesting for others too. Tom asked: Formula » Convert formulas to their values: I was hoping you could tell me if there is there a way to do this for all the ...

Almost finished: ASAP Utilities version 4.2.6

Busy

I'm almost finished with the updated version of ASAP Utilities: 4.2.6 Most changes in this version are corrections and bug fixes. More information and download: http://www.asap-utilities.com/faq-questions-answers-detail.php?m=185 We're also working on version 4.3 which will contain several improvements and a very big step forward (that I can' t reveal yet). This is consuming a great portion of our time, but ...

Count the occurrences of a character in a cell

count-character-in-string.gif

Just got a question that I found interesting to mention here: I am looking for following feature in ASAP Utilities: Count number of user specified characters in a cell. e.g. I have a cell that has values "a,b,c,d,e". I would like to have a utility that tells me either a. there are 4 "," characters b. simply tell me ...

Excel 2007 sheet copy: Application-defined or object-defined error

excel-2007-application-or-object-defined-error.png

When you use the code sheet.copy normally a new workbook is created with a copy of that particular sheet. However in Excel 2007 (SP1) if the original workbook contains a macro when you run the code the first time you (might) get the following error: I could only reproduce this error when the original workbook where ...

New ASAP Utilities version 4.2.5 released!

The new version of ASAP Utilities for Excel has just been released! This new version 4.2.5, May 29, 2008 is improved in a several ways. Read the full newsletter: http://www.asap-utilities.com/asap-utilities-newsletter-2008-03.php

Pre-release ASAP Utilities version 4.2.5 RC3

Updated: Export » Export worksheets as separate files...

I have just put a pre-release of the new version of ASAP Utilities online. This new version contains a few improved utilities and a few bug fixes.

Pre-release ASAP Utilities version 4.2.3 RC1

Error

Last week version 4.2.2. was released. Unfortunately this version contains a few bugs. I have solved these and a new version will be released soon. The most annoying bug is in the utility "Range » Find / Replace in all sheets...". When you pressed the "Find all" button you immediately got Error 401: Application-defined or ...

New ASAP Utilities version 4.2.2 released!

ASAP Utilities version 4.2.2 (January 22, 2008) has just been released! I would like to thank everybody for their feedback! Among other minor updates, these utilities have been improved: - Export » Export selected chart or range as image (file)... - Export » Export worksheets as separate files... - Import » Insert (delimited) text file... - Fill » List filenames in ...

Pre-release ASAP Utilities version 4.2.2 RC5

I have just released the fifth pre-release of the new version of ASAP Utilities 4.2.2 which contains several new features and bug fixes. This new version is scheduled to be finished by the end of next week (January 18). Minor updates and bug fixes will be done. Bigger updates will be reserved for the release after ...