Happy Holidays and Merry Christmas! Lots of love and happiness for you, your co-workers, family and friends. And if you don't celebrate Christmas, have a great weekend!

Posted on December 23rd, 2011 by Bastien
Filed under: General | No Comments »

"Hi Bastien, I am a great admirer of you ASAP-utilities. Great work. I have a little problem with Excel 2010, that I am hoping that you might have a solution to. We have just switched over to the excel-2010 from excel-2003. In the 2003 there was a button to send this sheet to an e-mail. [...]

Posted on November 21st, 2011 by Bastien
Filed under: General, How to | No Comments »

Today we received the following email: Let me start by saying how wonderful I think your program is. It saves me a lot of time. I just created 100 sheets and named them from a list using ASAP -great! I then inserted the name of each sheet into a cell within the sheet using ASAP [...]

Posted on November 16th, 2011 by Bastien
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities | No Comments »

I wish you all a wonderful new year with lots of health, happiness and prosperity! May the New Year be a good year to you and yours. And we'd like to thank you for your suggestions, enthusiasm and encouragement throughout the past 12 years. We've planned several new exiting and improved tools for ASAP Utilities [...]

Posted on January 3rd, 2011 by Bastien
Filed under: ASAP Utilities, General | 5 Comments »

Last week I received the following question: How we can spell check on all sheets. Can you add this in next version/update? Well, you can already do this in Excel. Just select all or multiple sheets and then when you start the Spelling (F7) the spelling check will take place on the selected sheets.

Posted on January 13th, 2010 by Bastien
Filed under: General, How to | Comments Off

Last week I received the following question: I get sent Excel files from various vendors. I have to convert these to SAS datasets that get moved to a UNIX system. The SAS datasets can only contain ASCII 32-127. So I need to remove these from the Excel file. You can use the "Text » Advanced [...]

Posted on August 13th, 2009 by Bastien
Filed under: General, How to, how to with ASAP Utilities | 3 Comments »

A bit off-topic but because working with shortcuts is often so much faster. I believe that shortcuts are are preferred when it comes to speed/productivity and reducing the chances on RSI. Microsoft: List of keyboard shortcuts for Word 2002, Word 2003, and Word 2007 http://support.microsoft.com/kb/290938 Just in case you weren't aware, we have a list [...]

Posted on November 19th, 2008 by Bastien
Filed under: General | 5 Comments »

When you send your Excel workbook to other people, sometimes you want to protect or hide certain parts. For example the formulas you used or temporary data in hidden columns. You can do this by using Excel's worksheet protection, however you should know that this protection is easily broken and not very secure. A better [...]

Posted on October 27th, 2008 by Bastien
Filed under: General | Comments Off

Below is something that I experienced a while ago and was beyond my logic. Setting a range and looping through all cells in it didn't work initially as expected. Sub WeirdCelLooping()      Dim rngCel                                       As Range      Dim rngSelection                                 As Range       Range("A1:G10").Select       ' Doesn't work correctly:      For Each rngCel In Selection.Columns(1)            ' both rngCel and the selection have now the same [...]

Posted on October 23rd, 2008 by Bastien
Filed under: General | 5 Comments »

A short macro that will unhide all columns and rows in order to make all data visible again. Might be useful in some cases. Sub UnhideAllColumnsRows() ' unhide all columns and rows on the current worksheet Cells.EntireColumn.Hidden = False Cells.EntireRow.Hidden = False End Sub If you want more control on which rows and/or columns to [...]

Posted on October 21st, 2008 by Bastien
Filed under: ASAP Utilities, General, How to, how to with ASAP Utilities | Comments Off