Filed under: ASAP Utilities on June 5th, 2006 by Bastien | Comments Off
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 attending a Microsoft Office System Developer Conference. I'm curious to see what they are up to and if everybody is wearing business suits or sneakers.
Filed under: ASAP Utilities on June 5th, 2006 by Bastien | Comments Off
Filed under: ASAP Utilities on June 2nd, 2006 by Bastien | Comments Off
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 before it appears.
Kind regards,
Bastien
Filed under: ASAP Utilities on June 2nd, 2006 by Bastien | Comments Off
Filed under: ASAP Utilities on May 30th, 2006 by Bastien | 3 Comments »
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 with more then 255 characters are now supported too.
- Fill » Insert filename... has now an extra option to create hyperlinks to the files. A copy of this utility has been made in the "Information" menu with the name "List filenames in folder..." Your settings will be saved and if you have Excel 2002/XP or later the "pick a folder" dialog will start with your last used folder.
- In the ASAP » Options... dialog I have added an extra option where your can choose to use the F11 key to switch between fullscreen mode
- New utility: System » Reopen current file without saving changes. Closes the current workbook without saving changes and then opens the last saved copy of the file.
- New utility: Text » Replace accented vowels (á, ë, etc.)... Replace the accented vowels in your selected cells with non-accented vowels. You can customize the settings.
- Text » Advanced character removal... New option to specify whether you want to replace in cells with constants, formulas or both.
- Added a new worksheet function: =ASAPSPELLNUMBERS(). This is a worksheetfunction of the utility Numbers » Spell numbers or amounts (EN, DE, NL)... A detailed description of this function will be given in the new User Guide.
- System » Close and delete current file. If possible the file will not be deleted but send to the Recycle Bin. If that is not possible you will get a question of you want to delete the file permanently.
- System » Create a lot of folders. If you have Excel 2002/XP or later the "pick a folder" dialog will start with your last used folder.
- Fixed: Inverse selection produced an error if you cancelled the selection of a cell.
- Fixed: Count unique values produced an error if your selection contained cells with an error.
- Fixed: Error in list filenames on finish or exit.
- Fixed: Use a significant number of decimals gave an error when you used it on cells without decimals. The speed of this utility is increased too.
- Fixed a bug in the Text » Convert dates... utility.
- Fixed a bug in the Import » Import Excel file... utility.
- Fixed a bug in the Import » Merge files... utility.
- Fixed a bug in the System » Rename current file... utility.
- Fixed a bug in the Range » Find / Replace in all sheets... utility in Excel 2003.
- Reset recent files list also resetted the amount of recent files back to Excel's default which is 4. This is now fixed and your setting will be kept.
- Fixed a few bugs in the apply formula utility.
- Fixed: HTML export, font tag not ended, aligment from cell not always correct (when not set it used the settings from the cell before)
- Delete all lines inside selection renamed to Delete all borders inside selection. This utility has also been updated to really remove only the interior borders. It used to remove all borders in your selection.
- Select all objects on current sheet gave an error if the sheet contained comments. A workaround has been made to make it work in that occasion too.
- More spelling errors corrected. More consitent use of certain words
- Several other small bugs have been fixed.
- This version will work in Excel 2007 beta too, although not all utilities have been fully tested in the new version of Excel.
Filed under: ASAP Utilities on May 30th, 2006 by Bastien | 3 Comments »
Filed under: ASAP Utilities on May 19th, 2006 by Bastien | 5 Comments »
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 for consistency in the language and some suggestions for new utilities or improvements. Thank you all! This way ASAP Utilities is getting better each time.
A new version will probably be released by the end of may.
Kind regards,
Bastien Mensink
Filed under: ASAP Utilities on May 19th, 2006 by Bastien | 5 Comments »
Filed under: ASAP Utilities on April 6th, 2006 by Bastien | 9 Comments »
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 replaced with a certain character.
(This can for instance be usefull to replace all characters in a Google adwords keyword list that are not allowed (everything but numbers letters and a dash), and have them replaced by a space. Later you can use ASAP Utilties to remove all excess spaces.)
- Select » Expand selection to last row
The last cell will be reset first before expanding your selection to the last row.
Will now also work on protected worksheets.
- Select » Expand selection to last column
The last cell will be reset first before expanding your selection to the last column.
Will now also work on protected worksheets.
- Export » Export selection as values to clipboard
Will give you a warning message if your selection contains cells with an error. You can then choose to continue or correct the errors first.
- System » Close all files except the current one
Has been renamed to:
System » Close multiple files at once...
- Improved progress indicators.
- Several small additions and improvements.
- Corrected some typing errors (thanks Peter!).
Filed under: ASAP Utilities on April 6th, 2006 by Bastien | 9 Comments »
Filed under: ASAP Utilities on April 4th, 2006 by Bastien | 5 Comments »
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.
Filed under: ASAP Utilities on April 4th, 2006 by Bastien | 5 Comments »
Filed under: ASAP Utilities on April 3rd, 2006 by Bastien | Comments Off
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 couldn't read the text anymore.
So I decided to use the fullscreen view in Excel. That way only the sheet and the main menubar are visible. I've also turned of the row and column headings. I used ASAP Utilities to show the flowchart toolbars and had all the space I needed.
But then I realized that quickly switching between fullscreen and normal view could not be done by a shortcut key. In most internet browsers you can use the F11 key to do this. So I choose to make my own F11 action in Excel. (By default the F11 key inserts a chart sheet in Excel and so will Alt+F1).
To be able to use the key F11 to toggle between fullscreen, I added the following code to my workbook:
The following code will toggle between fullscreen:
Sub sbToggleFullscreen()
If Application.DisplayFullScreen Then
Application.DisplayFullScreen = False
Else
Application.DisplayFullScreen = True
' to not show the fullscreen commandbar
' uncomment the following line
' Application.CommandBars("Full Screen").Visible = False
End If
End Sub
Read more...
Filed under: ASAP Utilities on April 3rd, 2006 by Bastien | Comments Off
Filed under: ASAP Utilities on April 3rd, 2006 by Bastien | Comments Off
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 the generated code in memory and in stead of that we now use a temporary file to build the code, and when that is finished, we load the file in one step into the memory and put it on your clipboard. On my computer a table with 14.000 cells now took 20 seconds to generate in stead of over 3 minutes.
The generated code is improved in some points. Empty </font> tags should now be gone and the order of the attributes (bold/italic/underlined) is improved, meaning that are closed in the reverse order from how they started. For example a cell that was
both bold and italic use to be in HTML <b><i>content</b></i> this is now <b><i>content</i></b>
Another improvement is the nowrap: nobr. This prevents word-wrapping a cell's content. This code used to be <nobr>content</nobr> in each cell. This is now replace by a CSS attribute on each row.
The past few days I received two bugs. After both the "Advanced Transposer..." and the "Export selection or sheet as new file..." utilities had run and you pressed the close button you recieved an error. These bugs are fixed in this new version.
Filed under: ASAP Utilities on April 3rd, 2006 by Bastien | Comments Off
Filed under: ASAP Utilities on March 30th, 2006 by 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 version.
Filed under: ASAP Utilities on March 30th, 2006 by Bastien | 1 Comment »
Filed under: ASAP Utilities on March 28th, 2006 by Bastien | 1 Comment »
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 progress indicator for a large part of the utilities. This also has the benefit that you can easily cancel an operation, for example if you have made a mistake and waiting for it to finish takes too long.
Read more...
Filed under: ASAP Utilities on March 28th, 2006 by Bastien | 1 Comment »
