Soon to be released: version 4.2.9
While I'm working on the next big updated version (4.3), a few people have found some bugs in version 4.2.8 that I've now fixed in version 4.2.9.
More information and download of the pre-release:
http://www.asap-utilities.com/faq-questions-answers-detail.php?m=195
This version will probably be officially released next Thursday.
Filed under: ASAP Utilities on November 18th, 2008 by Bastien |
Hi Bastien,
May the couple live 1000 years !
My wishlist is getting longer.
The in-built “Text to Columns” utility of Excel is somewhat limited in its approach. Perhaps there should be More than one “Other” delimiter boxes so that if one wants to separate for / , \ , ) , ( at the same time he can do it .
Regards
CA Kanwaljit Singh Dhunna
Hello Kanwaljit,
Thank you for thinking along.
I can see the benefit of such a tool. However in which kind of (business) situation would you need such a tool. In other words, what kind of documents do you get that should be splitted like that. Perhaps it is possible to convince people that they should provide their data in a better (separated) format.
Kind regards,
Bastien
Hi Bastien,
May the couple live 1000 years !
It spurred from a recent requirement to separate a file address into separate components. And the file address contained atleast two delimiters / and . (because even the document type was to be separated). Presently I can provide with the above example only. Not convincing enough though other peoples input may provide other scenarios too…..
Regards
CA Kanwaljit Singh Dhunna
Hi Bastien,
May the couple live 1000 years !
One more scenario regarding above. We are downloading our bank data in excel and most of the times it had to be splitted using more than 1 delimiters.
Regards
CA Kanwaljit Singh Dhunna
Hi everybody,
it would be nice to have an utility, that will split a cell not only into columns, but into rows too. Afaik, there’s no easy way to do it in excel without help of 3rd party utils.
And many thanks for ASAP, of course :)
Hi Bastien,
May the couple live 1000 years !
Please guide me !
I am maintaining a file in excel for banking entries and it contains VBA code for its working. With the passage of time the code keeps changing. I want to maintain the “Bank Book” version wise. But don’t know when to give a new version number to it .
Regards
CA Kanwaljit Singh Dhunna
Hi Bastien,
May the couple live 1000 years !
First of all, kindly increase the width of this comments box. 2ndly Today I used the “Delete all objects on the selected worksheets” on one of my worksheets. This sheet contains validation on 4 columns having 1000 rows each (In-cell dropdown check box is “checked”, off-course). But the validation dropdown menu on all the columns have ceased to appear. Whereas there is no problem on all the other worksheets. Also the Filter Dropdown on the Header Row are intact. I suspect it happened due to the use of above Utility. But you can verify it better :)
If yes, it would be better to give options for which objects to delete and which not.
Kind Regards
CA Kanwaljit Singh Dhunna
Hello Kanwaljit,
Thank you for your feedback.
As you will see now the comment box is wider now.
The utility does indeed remove the dropdown arrows from the cell validation dropdowns. Apparently the code “shapes.delete” will also remove these dropdown arrows. I will update this / rewrite the utility in version 4.3.0 which will soon be pre-released.
Kind regards,
Bastien
Hi Bastien,
May the couple live 1000 years !
Thanks for the BIG comment box. It seems finer now. I will wait for the next version. For the last 3 months I am battling with an issue, but couldn’t get around it. After trying most of my sources, very hesitatingly I am putting it to you for guidance. In a Workbook I have database for 4 banks. For Printing Cheques from Excel I have a separate sheet for Each Bank having customized dimensions for that particular bank. But I want to change it, so that all that can be accommodated on a single Userform having 6 text boxes. Now I have maintained a dimensions (in cms) database containing Bank Name, Name of the Text box, Width of the text boxes, Height of the text boxes, distance between different text boxes and the distance of each text box from the top edge and left edge. What I wish is that whenever I select the name of the Bank from a Validation List, the dimensions of the Userform changes as per the Dimensions Database for that particular bank. Being a greenhorn in VB, till now I only have Userform alongwith the text box on it. Don’t know how to do the dimensions trick and how to apply the dimensions vlookup for different banks. Can you guide me in the proper direction.
Kind Regards
CA Kanwaljit Singh Dhunna
Hello Kanwaljit,
I would just make the userform so that the information from the largest textboxes can be shown.
This way the layout will stay the same, which is easier/clearer for the user.
You could create a dynamic layout by using the events from the controls on the userform, but I wouldn’t recommend it in this case.
If you want to discuss it more, please send me an email.
Kind regards,
Bastien