Bastien - ASAP Utilities Blog

Soon to be released: version 4.2.8

Sep 16, 2008 Bastien 0 Comment

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

ASAP Utilities General

Replace formulas with their calculated results in multiple sheets

Sep 16, 2008 Bastien 2 Comment

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

ASAP Utilities

Almost finished: ASAP Utilities version 4.2.6

Aug 5, 2008 Bastien 6 Comment

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

ASAP Utilities how to with ASAP Utilities

Count the occurrences of a character in a cell

Jul 2, 2008 Bastien 5 Comment

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

General

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

Jun 3, 2008 Bastien 0 Comment

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

ASAP Utilities

New ASAP Utilities version 4.2.5 released!

May 30, 2008 Bastien 2 Comment

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: //www.asap-utilities.com/asap-utilities-newsletter-2008-03.php

ASAP Utilities

Pre-release ASAP Utilities version 4.2.5 RC3

Apr 28, 2008 Bastien 1 Comment

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.

ASAP Utilities

Pre-release ASAP Utilities version 4.2.3 RC1

Jan 31, 2008 Bastien 4 Comment

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

ASAP Utilities

New ASAP Utilities version 4.2.2 released!

Jan 22, 2008 Bastien 3 Comment

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

ASAP Utilities

Pre-release ASAP Utilities version 4.2.2 RC5

Jan 9, 2008 Bastien 2 Comment

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

General

Google Desktop Search slows down Excel

Dec 20, 2007 Bastien 0 Comment

Do you read the website "Daily Dose of Excel"? If not, it is a very interesting website about Excel. Frequently updated and many interesting discussions. Today I want to share an article with you: This week Dick Kusleika posted a very interesting article where he quoted Charles Williams from DecisionModels.com. Charles Williams is an absolute expert in ...

ASAP Utilities

Office 2007 Service Pack 1 coming on December 11th

Dec 6, 2007 Bastien 1 Comment

For your information, next Tuesday the first Service Pack for Office 2007 will be released. Service Pack 1 for the 2007 Microsoft Office system will be available for download on December 11th. We will be sharing more details at that time, but the improvements are focused on stability, performance and security. I'm very curious if the ...

ASAP Utilities

Pre-release ASAP Utilities version 4.2.2 RC1

Nov 28, 2007 Bastien 10 Comment

I have just released a pre-release of the new version of ASAP Utilities which contains several extended utilities (mainly import/export) and a few bug fixes. I would like to thank everybody for their feedback! New/improved Export » Export worksheets as separate files...Improved, you can now specify in which file-format you want to save the sheets.If you have Excel ...

ASAP Utilities

Review: ASAP Utilities – You Sexy Thing

Nov 20, 2007 Bastien 12 Comment

Did you know that ASAP Utilities is sexy? I didn't too but I found out it is yesterday when I read the following review on the UK website Dooyoo! by raehippychick. I would like to share her enthusiasm with you. Review by 'raehippychick' Advantages: Brilliant for any Excel user - simple, easy to use, saves time and tempers Disadvantages: ...

ASAP Utilities how to with ASAP Utilities

Video: How to fix trailing minus signs in Excel with ASAP Utilities

Nov 9, 2007 Bastien 5 Comment

The following video will show you how to how to fix trailing minus signs in Excel by using ASAP Utilities. This can be useful if you have imported data from a system that reports negative numbers with a trailing minus. If you've ever worked with imported numbers you might have faced the problem that negative numbers have ...

ASAP Utilities how to with ASAP Utilities

Video: How to delete all empty rows in Excel with ASAP Utilities

Nov 5, 2007 Bastien 0 Comment

Example file with empty rows that need to be removed

The following video will show you how to remove all empty rows in Excel by using ASAP Utilities. This can be useful if you have a large amount of data imported or copied together that you now want to clean up. An approach to remove all empty rows can be to sort the worksheet. However if you ...

General

Problem with copying filtered data in Excel 2007 + workaround

Oct 25, 2007 Bastien 49 Comment

I just got an email that says you cannot copy only the filtered data in Excel 2007. If you use the autofilter to make a selection and then you only want to copy the filtered rows, Excel 2007 copied everything, even the hidden rows. This is different from the way Excel 2000-2003 works. You can recognize ...

ASAP Utilities General

Protect sheets: The EnableSelection property is not saved + Excel update fix

Oct 23, 2007 Bastien 0 Comment

Yesterday I got the following question: "When using the 'protect multiple sheets at once and checking only the 'select unlocked cells checkbox I find that once I save and reopen the sheets now behave as if both the 'select unlocked cells as well as the 'select locked cells seems to be in effect as I ...

ASAP Utilities how to with ASAP Utilities

Video: How to delete the first 3 characters in a column in Excel with ASAP Utilities

Oct 22, 2007 Bastien 0 Comment

How to delete the first 3 characters in a column - before

The following video will show you how to strip the first 3 characters from a column in Excel by using ASAP Utilities. The example in the video shows a list of article numbers. Now in this case we want to remove the first 3 characters. This can be done with an Excel formula such as =RIGHT(A2,LEN(A2)-3) in a ...

ASAP Utilities how to with ASAP Utilities

Video: How to fill empty cells with the value above in Excel with ASAP Utilities

Oct 22, 2007 Bastien 0 Comment

Copy values to empty cells below filled cells in selection - before

The following video will show you how to fill empty cells with the value above in Excel by using ASAP Utilities. The example in the video shows a table with several car-brands. Now in this case we want the brand-names copied down so that the empty cells are filled with the brand names. After this we can ...

ASAP Utilities how to with ASAP Utilities

Video: How to sort the sheet-tabs in Excel with ASAP Utilities

Oct 18, 2007 Bastien 1 Comment

The following video will show you how to sort the sheet-tabs in alphabetical order in Excel by using ASAP Utilities. The example in the video show a workbook with several sheets with city-names: In the Excel menu choose ASAP Utilities » Sheets » Sort all sheets in alphabetical order Then result will then look like: Note: This old video is no ...

ASAP Utilities

Fixed the statup delay in Windows XP + Excel 2007 when opening a file through the Windows Explorer

Oct 12, 2007 Bastien 2 Comment

The latest version of ASAP Utilities (pre-released today) will solve an issue that can appear when you have both Windows XP and Excel 2007 installed. "After installing the latest version of ASAP-Utilities after upgrading to Office 2007, I began to encounter a problem with Excel 2007 where, upon clicking on an Excel file to open, the ...

ASAP Utilities

Pre-release ASAP Utilities version 4.2.1 RC3

Oct 12, 2007 Bastien 3 Comment

Example of the function =asaprandompassword()

I have just published a new pre-release of the new version of ASAP Utilities. It is ready for download and testing. In this update have made a few small improvements and added a new worksheet function that make creating strong passwords easy: =ASAPRandomPassword(length, use_symbols)This new function will return a strong password which contains of - both uppercase ...

ASAP Utilities how to with ASAP Utilities

Video: How delete leading, trailing and excessive spaces in Excel with ASAP Utilities

Oct 11, 2007 Bastien 0 Comment

Example of leading, trailing and excessive spaces

The following video will demonstrate you how to delete leading, trailing and excessive spaces from cells (trim) in Excel by using ASAP Utilities. The example in the video shows an address list with too many spaces: Several street- and city names contain a space at the beginning and/or at the end. Furthermore in a few names there are ...

ASAP Utilities how to with ASAP Utilities

Video: How to extract hyperlinks in Excel with ASAP Utilities

Oct 10, 2007 Bastien 1 Comment

The following video will demonstrate you extract hyperlinks from cells in Excel by using ASAP Utilities. The example in the video show a list of websites that I copied from my links-page. There is no easy way in Excel itself to get the hyperlinks from the cells. That's why I built such a functionality into ASAP Utilities. First ...