73 Responses to “ASAP Utilities 3.11 beta 28 march released”

1. sandra, on January 10th, 2006 at 6:23 pm Said:

   Won’t down load ..get error stating that there is a DLL error

2. Bastien, on January 10th, 2006 at 6:28 pm Said:

   Hello Sandra,

   I’ve send you an email, please check it and send me more information about you Excel/OS version and when you get the error and what the error message is.

3. Monty, on January 10th, 2006 at 10:43 pm Said:

   Fill ‘between values’ linear in selection (Horizontal) does not work. It didn’t work in the previous version (3.10) either.

4. Bastien, on January 10th, 2006 at 11:20 pm Said:

   Hello Monty,

   Thank you, I’ve corrected it and I will soon publish an updated beta-version.

5. Bastien, on January 15th, 2006 at 8:39 pm Said:

   Several people have sent me some good feedback on the beta 3.11 f version of 5 january (thanks!). I’ve used these suggestions to make improvements and now a new beta version is available: 3.11.h 15 january 2005.

6. Kyle, on January 16th, 2006 at 4:44 pm Said:

   3.11h jan. 15
   radio buttons stay selected in convert numbers dialogue, cannot change conversion option in convert numbers dialogue after initial selection is made.

7. Bastien, on January 16th, 2006 at 4:53 pm Said:

   Thank you Kyle, it will be corrected in the next update.

   The problem exists in:
   Text » Convert dates…
   Range » Paste special (with combinations)…
   Numbers » Convert negative numbers to positive and vice versa…

8. Jay, on January 16th, 2006 at 10:15 pm Said:

   Web>Clean Web Imported Data has a checkbox to remove all hyperlinks, but it doesn’t appear to function properly, although Web>Remove all hyperlinks in selected cells does work. Also, it would be nice if the checkboxes would default to the configuration selected the last time the utility was used, instead of having to uncheck undesired options every time.

9. Bastien, on January 16th, 2006 at 10:34 pm Said:

   Hello Jay,

   What doesn’t work in the Web >> Clean Web Imported data…?
   Can you send me an example workbook? I can’t reproduce it, both utilities seem to work fine, so please give me more information.

   I’ll make the utilities remember you settings in the final version.

   Kind regards,
   Bastien Mensink

10. Eric, on January 17th, 2006 at 4:32 am Said:

    Cannot load into excel , error msg “Something went wrong, build menu 7; Out of memory, restart excel againt”

11. Bastien, on January 17th, 2006 at 11:19 am Said:

    Hello Eric,

    Do you get this message everytime?
    Which windows version and which Excel version do you use?
    Did you have any problems with ASAP Utilities version 3.10?

    Kind regards,
    Bastien Mensink

12. Bastien, on January 18th, 2006 at 10:03 pm Said:

    Thank you for all the testing and suggestions.
    I have just put a new version online: 3.11.i beta 18 january 2006.

    - improved startup error-handling
    - Web » Clean Web Imported data…
      The layout is improved. Your last used settings will be remembered.
    - Export » Export selection as HTML table to clipboard…
      Your last used settings will be remembered.
    - Export » Export selection or active sheet as new file…
      Your last used settings will be remembered.
    - Export » Export selected chart or range as image (file)…
      Your last used settings will be remembered.
    - Several small additions and improvements.
    - Range » Paste Special (with combinations)…
      Operations (like multiply) now function too
    - Fixed the bugs with the radiobuttons on some forms:
      Text » Convert dates…
      Range » Paste special (with combinations)…
      Numbers » Convert negative numbers to positive and vice versa…

13. William McNeill, on January 19th, 2006 at 3:15 pm Said:

    I simply adore ASAP utilities it makes life much more bearable.

    I am a civil servant working for an Agency that has a very strict policy on installing programmes on our local PC’s due to all sorts of copyright issues.

    This new version while looking excellent is out of bounds to me as I don’t have sufficient priviliges and because my department does not “own” the package I am not allowed to have the updated utility, now in .dll format.

    I will have to stick with my 3.1.0 version

    Excellent product in all respects - very well done and good luck with 3.1.1

14. Monty, on January 24th, 2006 at 1:05 am Said:

    Fill linear Horizontal and Vertical (although, working now) are switched with each other in what they do.

15. Monty, on January 24th, 2006 at 1:07 am Said:

    convert formulas to values gives an error - also did in the previous versions

16. Monty, on January 24th, 2006 at 1:08 am Said:

    shortcuts not workings

17. Bastien, on January 24th, 2006 at 9:54 am Said:

    Hello Monty,

    Thank you. The first two of your comments will be solved. The third, shortcuts not working, I can’t reproduce. Can you send me information by email about the Excel and Windows version you are using.

    I’m now preparing a new beta that will be be published here within a few hours.

18. Bastien, on January 24th, 2006 at 11:03 am Said:

    Hello,

    I have published a new beta version which solves all bugs yet reported. In a moment I am also going to publish version 3.10b that works without the DLL and does not require administrator rights to install.

19. Gagandeep Singh, on January 25th, 2006 at 6:00 am Said:

    Dear Sir,
    First of all, congratulations for developing this wonderful utility.

    I am facing a problem regarding merging of records from several sheets. Each sheet contains several records recognised by employee number. However, a particulars employee number is there in one sheet or more sheets but not in all.

    I want data of all the employees in one single sheet.

    How can your asap utility help?

    Regards,

    Gagandeep Singh

20. mateusz, on January 25th, 2006 at 9:59 am Said:

    Hello!
    When do you plan to issue the 3.11 version as official one?

    regards
    Mateusz

21. Howard, on January 25th, 2006 at 10:19 am Said:

    When I install this version I get the following error

    Unexpected error (50001)

    Running Office 2003 SP2 on WinXP SP2 etc

22. Arnie, on January 25th, 2006 at 12:31 pm Said:

    Too bad,
    I hope the old add-in version will be maintained. At the office I don’t have administrator rights. therefore installing 3.11beta is impossimble (can’t register the .dll error in excel)

23. Torsten, on January 25th, 2006 at 4:22 pm Said:

    Hello Bastien,

    thanks for providing us with this great time-saving Add-In. I have presented your add-in as an invaluable tool in every excel training I have held for my company.

    Unfortunately, the new version can only be installed by someone with admin rights, which imposes a problem for a lot of people using your tool at the office. For example, in my company is it very difficult to get software installed which is not approved and tested by our IT department and it’s likely that most of the companies have similar policies.

    Maybe it’s possible for you give us the option to register the dll to HKEY_CURRENT_USER instead of registering it to HKEY_LOCAL_MACHINE? This would spare some of your loyal users a lot of trouble.

    If you have developed the dll with Visual Basic, you can use vbadvance to make it possible to register the dll without administrative privileges. vbadvance is an add-in for VB, which is available for a very moderate price (€33.50). Below you find the relevant paragraph from www.vbadvance.com.

    - snip -
    DllRegisterServer / DllUnregisterServer customization - An extension of the Function Exports feature, the ability to override and customize these two registration exports gives you full control over your DLL’s registration. For example, starting with Windows 2000, you have the option to register an ActiveX DLL to HKEY_CURRENT_USER instead of HKEY_LOCAL_MACHINE, thus avoiding the permissions problems some customers face. Unfortunately, VB gives you no way to specify this change. vbAdvance does. Using vbAdvance, you can easily change the Registry hive your DLL or OCX is registered under. You could also easily add any custom code you wanted to run at registration time.
    - snip -

    I would be glad if you would consider providing us with the option to install the new version without administrative privileges.

    Regards,

    Torsten

24. Bastien, on January 25th, 2006 at 4:53 pm Said:

    Hello Torsten,

    As an alternative there is a version of ASAP Utilities (version 3.10b) that can be installed without administrator rights. However this version does not contain some new features that were introduced or improved in version 3.11.

    I am currently investigation the posibilities for network installations and limited used rights. That is one of the reasons why the new 3.11 is still a beta version.

    Kind regards,
    Bastien

25. sat, on January 25th, 2006 at 7:03 pm Said:

    Hi,
    I have been using ASAP since last six months, our office doesn’t have Internet .SO I have to upgrade it at home..
    WHy don’t you make a version which doesn’t require any update..( earlier version runs just fine..and I don’t think it needed any upgrade :-) )
    Anyways, accept my thanx for such a wonderful utiliry..
    I wish I could do that tooo :-)

    Regards.
    SAT

26. Nick Gazzana, on January 25th, 2006 at 9:37 pm Said:

    Have tried to update asap. Keep getting message about deletefile failed code 32. being used by another process… tried several sites and the 3.11 beta . same results.

27. AOlson, on January 25th, 2006 at 10:42 pm Said:

    Unwrap favorite and toolbar call up the Remove all empty rows macro. Works okay from the menu.

28. John Tabor, on January 26th, 2006 at 4:11 pm Said:

    Wonderful program. Tried to use 3.11M beta, it installs just fine using admin rights. Loads when Excel starts the first time after that I get the error message saying something went wrong ASAP Utilities could not load.Checked the security tab and trust all installed addin box is checked. Do I have to be logged in as admin each for it to run? Had to reinstall 3.10b and it runs just like it should with no problems. Using Excel 2003 SP2 on an XP machine.
    Thanks for a wonderfull program,
    John

29. Bastien, on January 26th, 2006 at 5:04 pm Said:

    Hello John,

    Unlike what all the documents say and how it should be there are problems with XP limited accounts. Somehow Excel will not load the DLL despite the fact that it is registered for all users. I have tested it with Excel 2000 and that works find. I’ve also heard that Windows terminal server works fine this way.
    I’m currently investigating what to do with this problem with XP limited accounts.

    Kind regards,
    Bastien

30. Bastien, on January 27th, 2006 at 5:40 pm Said:

    Hello,

    An updated beta version is just published, version 3.11.n (27 january 2006).
    This solves all reported bugs so far regarding the excel-functionality, not the problem with limited user rights and DLL registration. I also took the opportunity to expand the “protect all sheets” utility.

    Please upgrade to this new release. Thank you for helping/testing.

    Kind regards,
    Bastien

31. SALim Kazi, on January 28th, 2006 at 12:38 pm Said:

    wow,

    wonderfull work …. i have not seen such a add-in utilities in my life. although i am using excel for more than a 8 years!!! i am success full in getting all the information i want …….. but using your utilities ……. i save lot of time ………

    Thanx for everything…….

    I have just install your new version of beta 3.11n…….. so far working okay

    Do Em@il

    SALim

32. vaibhav, on January 29th, 2006 at 10:24 am Said:

    your addins are fantastic. it is very useful for prepairing reports in excel.
    currently i’m using 3.10 in that there is function of print multiple sheets.
    this facility is great but it that addin if i set the printing setup as a draft mode it take only first printout in draft mode and all other in normal mode that is good quality prints. Is it possible for you to give such option that once i set a specific print option then it will applicable to all sheets?

    pls reply

    regards

    vaibhav

33. T Smith, on January 29th, 2006 at 11:31 pm Said:

    Great utility. I have been using excel for ~10 years and this is the best utility add-in I’ve come across. I think there is a minor bug with the launch Symbol (charmap), launch calculator, & launch notepad as they all flash on top of excel and then hide behind the excel window.

34. Bastien, on January 30th, 2006 at 12:23 pm Said:

    Hello,

    An updated beta version is just published, version 3.11.o (30 january 2006).

    This update solves the problem with the “launch” application not being on top of Excel. It also fixes a bug in the help-form and the conditional select/hide/delete when your selection contained multiple areas.
    The advanced character removal now remembers you last used settings.

    Please upgrade to this new release. Thank you for helping/testing.

    @vaibhav, You can change a printer in the setup dialog, however changing the printer settings that way only has effect on the first page. This is the way it currently works but I will see if I can fix it in a next update. Then I will also implement continuous page-numbering.

    Kind regards,
    Bastien

35. Harlan Chizen, on January 30th, 2006 at 2:58 pm Said:

    The new User Guide is great. I’m an experienced user of both Excel and the ASAP Utilities, and I find most user guides are useless, but the How-To section showed me some techniques I’d never thought of. ASAP is even better than I knew!

36. carlos, on February 1st, 2006 at 2:01 pm Said:

    Congratulations excelent proposall to professional as us.-

37. Ron Hoffman, on February 2nd, 2006 at 4:26 pm Said:

    We use job numbers to track our accounting. When I qwery the data base
    all rows contain a unique number in sequence the same is true for invoice #, packlist #, receit # …….
    For audit purposes I need to set a range (col) and would like to find any missing numbers and have them inserted into an adjacent col. and new row
    and displayed on a new worksheet.

    Thank-You

38. Keorke, on February 5th, 2006 at 9:57 am Said:

    There’s one minor annoyance (still in 3.11.o) in the Merge column data (join cells), which I use a lot. In the dialog the focus is on the OK button and when I press space (to use it as a separator value) OK button is pressed and the data is merged wrongly. Well, nowadays there’s quite good undo but still… I think the focus should be on value field in the dialog in stead.

39. Cheda, on February 6th, 2006 at 10:18 am Said:

    Hi, the beta installer should check if Excel is already running - it comes with the error, saying that the *.xla file is already in use.

    After Excel is closed and Retry button is clicked, everything works.

    And one more thing, PivotTables and PivotCharts are (still) not very well represented in ASAP utilities ;-)

40. Robert, on February 6th, 2006 at 5:31 pm Said:

    Hello,

    I’m using the 3.11m beta and found that sorting on cells colour works ones or twice and than no longer unless closing Excel and reopening it.
    Have you already acknowledged this problem.
    BR
    Robert

41. Doug, on February 6th, 2006 at 7:33 pm Said:

    Just installed 3.11o beta and the List All Range Names under Information doesn’t seem to work. A new workbook opens up with Name: and Refers To: column headers, but no names. The original workbook has numerous named ranges in it. Using Excel 2003 with WinXP.

42. SALim Kazi, on February 7th, 2006 at 5:31 am Said:

    Hi Bastien,

    I just want to know your latest version so that i can update my system accordingly.

    Thanx

    Do Em@il

    SALim

43. Bastien, on February 7th, 2006 at 9:08 am Said:

    Hello Salim,

    The latest official version is 3.10b, available from www.asap-utilities.com.
    The most recenter beta-version of the new 3.11 is listed at the top of this page. In the version we always also put the release date, so this is 3.11.o 30 january 2006

    ———————-

    Hello Doug,

    Thank you for testing.

    This bug will be fixed in the next update.

    ———————-

    Hello Robert,

    I cannot yet reproduce this but I will look into it.

    ———————-

    Hello Scott,

    You do not have to type in a colorcode here, you have to select
    a base cell which has the color you want to select by.
    I will put an example of this in the next version of the User Guide.

    ———————-

    Hello Cheda,

    I believe the installer tells you to quit excel if it is running.
    I will update the error-message.

    I do not work very much with pivottables and pivotcharts. If you have
    suggestions just send them to me.

    ———————-

    Hello Keorke,

    Thank you for testing. I wil change this in the next update.

    Kind regards,
    Bastien Mensink

44. Doug, on February 7th, 2006 at 4:12 pm Said:

    Hi Bastien,
    Came across another “quirk”. Using 3.11o beta in Excel 2003 with WinXP, when I click on the “X” to close Excel (not the worksheet), the ASAP menu item disappears, then the dialog box comes up and asks if I want to save my changes. If I really wanted to close Excel, no problem and I save or don’t save. If I didn’t really want to close Excel, and choose cancel, the menu item is still gone, and I have to go to Tools|Add-Ins and UNselect ASAP, then REselect to reload it. Not sure if you would consider this a “bug” but I thought I would mention it.

45. Ch.V.Madhu, on February 10th, 2006 at 9:58 am Said:

    hello sir

    thank u very much for given new one beta.this is very useful for me and
    lot of time saving.once again thank you

    Regards
    Ch.V.Madhu
    Hyderabad-India

46. gerhard, on February 12th, 2006 at 11:02 am Said:

    hi there
    i just got this from my girlfriend . wow this is so great .!!

    i was wondering if you can help me ? in excele the comments can be formatted when put in . is there a way how i can change the defult font setup . so that i have a other font than tahoma as defult for the comments

    great utility

    thanks
    Gerhard

47. M K Jain, on February 14th, 2006 at 12:04 pm Said:

    I have been using the ASAP utility for almost 7-8 months. This has helped me in daily working greatly.

    In current verson you have taken care of advanced sorting based on so many criteria (unbeliveable). Can you please see similer type of facility for Conditional Format under format Menu.

    Wish you thanking you very much and all the best in efforts put in area, where no one else has helped even not Microsoft.

    Kind Regard

    M K Jain

48. Kitty Evans, on February 14th, 2006 at 11:35 pm Said:

    I am using 3.11m (& loving it) with Excel 2003/Windows 2K. I’ve stumbled on a quirk in one of the utilities. When you have a multiple-sheet spreadsheet and you apply the Format from one to all the sheets, one attribute does not copy correctly at a certain setting. If you set the Page Setup/Scaling to Fit to : 1 page Wide by pages Tall, all the pages but the original page fill in a 1 for the making it 1 Wide by 1 Tall.

    Respectfully submitted,
    KF Evans
    Florida, USA

49. Rafael, on February 16th, 2006 at 10:47 am Said:

    Hi Bastien,

    wonderfull work you’re doing.
    Not a bug, just a comment. If I read well, *.asap are not needed, cos replaced by dll. When installing over aprevious version, old files/not needed are not removed.
    Keep going this way ;-)
    Regards
    Rafael

50. Rafael, on February 16th, 2006 at 10:55 am Said:

    … just another comment.

    Thought about menu translation into other languages? I´m sure a lot of users would help. I would offer translations into spanish and german.
    If interested, just drop me an email ;-)
    Regards
    Rafael

51. Ch.V.Madhu, on February 18th, 2006 at 10:34 am Said:

    Sir,

    I want Organisation chart in ASAP-Beta.Please create coming version and i am facing one problem in excel.shortcut keys are not working. firtst one is ctrl+alt+I & ctrl+alt+L.

52. Edouard, on February 27th, 2006 at 2:22 pm Said:

    I’m simply not capable of ‘applying a formula’. No matter what I do (apply the formula to a value, another formula or a reference) I always get the same error in my both my Windows Server 2003 & my Xp set up with Excel 2003.

    Suppose my formula is: *100 (or even - 100), the error reads:

    Sorry your formula generates an error: Method Calculate van klasse Range is mislukt. Please re-check your formula: [*100].

    Common mistakes are the incorrect use of decimal separators (…) thousandsseparator (…) list separators.

    _(n.b. you’ll notice there is no such separator)_

53. Paolo, on March 8th, 2006 at 11:31 am Said:

    hi, on my pc version 3.10 is running. I’m trying to install version 3.11 but I
    received a “Startup Error”: “Sorry, something went wrong , I can’t connect to c:\program files\asap utilities\asap_utilities.dll”. I checked “Trusted add-ins” but received the same error. I’m administrator, so I registered dll with no problems. Any idea? thanks for your support

54. Edward F. Voelsing Jr, on March 9th, 2006 at 7:21 pm Said:

    I continually get the “Error” message. I would like to get the updates on a disk, if possible?

    Thanking you in advance,

    Ed Voelsing

55. AOlson, on March 10th, 2006 at 6:44 pm Said:

    Bastien-

    Great add-in! Look forward to seeing the bugs worked out on the 3.11 version.

    The Merge Columns and Merge Rows macros do not work. For Merge Rows get a text box asking to select rows even though they were already selected. For Merge Columns, get the form for adding an intermediate character or linefeed, etc, but merge does not happen.

56. arc, on March 11th, 2006 at 9:03 am Said:

    i am not able to set up it says files are corrupted

57. Rob, on March 16th, 2006 at 6:35 pm Said:

    I’ve used the older versions of ASAP utilities and it is a great add-in.

    I tried the beta 3.11 version and after I installed it everytime I start Excel 2003, the installer for Visual Studio 2005 (which I also have installed) comes up and runs. I let it run all the way through which took some minutes hoping it would go away, but the next time I started Excel it came back. I tried repairing my VS 2005 install (which took about 30 minutes) and it didn’t solve the issue. The only fix I found was to uninstall 3.11.

    I didn’t look into the issue very deeply, but there is probably a file that the 3.11 is installing that is older than the version in Visual Studio 2005.

    I’m back to 3.10 which is fine for now.

58. J Mooney, on March 20th, 2006 at 7:11 pm Said:

    FYI: Not sure what may be the cause, but have downloaded the 3.11 Beta version three times over 2 separate sessions (weeks apart). In all 3 downloads, [all over dial-up @ 45 kps], have had download end at 868,272 bytes, showing @ 85%. Download window indicated file size of 1 MB, which correlated well with the % download running value.

    In all 3 cases, when ran the EXE, an error message popped up saying the file was corrupted [which could be the case if the download terminated early] but 3 times over 2 separate sessions? Seems odd to me. Figured it was at my end first 2 times, but as the third was an immediate re-start after the 2nd failure, I have just about ruled that out. Have had no similar problems with downloads on this pc or dial-up link. Its just slow, but line condition is good.

    PC is

59. Bob Saunders, on March 21st, 2006 at 5:59 pm Said:

    I have been using your ASAP utility for over a year and I love it!. I downloaded the 3.11 Beta a couple of weeks ago and encountered the following problem:

    I have several text files I am trying to merge into a single worksheet. (I have done this same process for months with previous versions).

    Import>Merge together in a new file>Text file, pipe (|) seperated>Merge into 1 sheet

    Then I select the files I want merged. I usually pick dozens but for testing I was able to get the error with only 2. When I click “Merge files” I get the following error:

    Runtime error “-2147221080 (800401a8)”
    Method “~” of object “~” failed.

    The files I am selecting are text files that have the extention “.excl” They actually do not have any pipe characters. I use that option because I want the rows imported into a single column and I have to use text-to-column to parse the data out… there is no delimiter in the row that is consistent.

    Bob

60. Bob Saunders, on March 21st, 2006 at 6:05 pm Said:

    Just quick note, I uninstalled the beta 3.11 and downloaded 3.10 and the retryed the steps above. It worked just fine. Thanks

    Bob

61. Bastien, on March 22nd, 2006 at 4:12 pm Said:

    Hello all,

    I have just put a new version online, 3.11.s d.d. 22 march 2006. This fixes most bugs currently reported and has a few new/enhanded utilities.

    Thank you all for testing,

    Kind regards,
    Bastien

    To answer a few comments (if not already done by email):

    ———————-

    Hello Bob,

    Please upgrade to the most recent version.

    ———————-

    Hello J Mooney,

    Perhaps something is wrong with your internet provider. The file online is complete. You could try the alternative download location which is on a different server.

    ———————-

    Hello Rob,

    This is strange. I don’t have Visual Studio installer so I cannot reproduce it. However both 3.10 and 3.11 use the same setup program.

    ———————-

    Hello arc,

    Please download again, try the alternative download location or request the file by email.

    ———————-

    Hello AOlson,

    Please upgrade to the most recent version. If you still have problems, can you send me an example file? I am not able to reproduce the error.

    ———————-

    Hello Paolo,

    Can you test it again with the current version?

    ———————-

    Hello Edouard,

    Can you send me an example of the workbook in which you are getting the errors?

62. Paul Winter, on March 22nd, 2006 at 11:43 pm Said:

    Is there a way to assign the “Convert formulas to their values” macro (or any other ASAP macro) to a button on a toolbar?

63. Bastien, on March 23rd, 2006 at 8:40 am Said:

    Hello Peter,

    I find it easier to use keyboard shortcuts. By default the shortcut for
    “Convert formulas to their values” is Control+Alt+P. You can assing your own shortcut keys in the favorites menu.

    To use a button; you can do this by dragging an item off the ASAP Utilities toolbar. First create it:
    ASAP Utilities » ASAP » (Re)build the ASAP Utilities toolbar

    You can adjust the size of the toolbar by dragging its border.
    If you wish to remove toolbar buttons you never use, select in the menu:
    View » Toolbars » Customize.
    You can also right-click on the toolbar and choose “Customize…”, the last item in the popup.
    Then drag the unwanted buttons away from the toolbar or drag them to your own bar. When you’re finished, click Close to close the Customize dialog box.

    Kind regards,
    Bastien Mensink

64. andy, on March 23rd, 2006 at 10:14 am Said:

    Mr. Bastien,
    I installed the beta release ASAU Utilities 3.11 and this is the outcome after installation.

    Error message

    Unable to execute file:
    C:\Program Files\ASAP Utilities\install as addin.xls

    ShellExecuteEx failed;code 2
    The system cannot find the file specified

65. Bastien, on March 23rd, 2006 at 10:42 am Said:

    Hello Andy,

    This is strange. Usually running the “install as addin.xls” will start Excel and open the file.

    The workaround now is to perform the installation again, and UNcheck the checkbox in the last screen that will ask you if you want to have ASAP Utilities installed as addin everytime Excel start.

    Then after the installation is finished:

    1. Run Microsoft Excel
    2. On the tools menu, choose Add-Ins.
    3. Use the “Browse…” button to locate the ASAP Utilities.xla file (default is C:\Program Files\ASAP Utilities\)
    4. If Excel asks you to copy the file to the library folder, answer “no”.
    5. Check the “ASAP Utilities” check box.
    6. Next to “Help” in the menu, there is an option called “ASAP Utilities”.

    Kind regards,
    Bastien Mensink

66. Edouard, on March 23rd, 2006 at 3:55 pm Said:

    Bastien,

    ‘applying formula’ works in the newest beta version 3.11s, but not in version 3.10 (which I use at work). Every spreadsheet gives the same error. Even simply entering 12, 13, 14, 15 in cells A1 through A4 and subsequently highlighting these cells and applying the formula *12 gives the mentioned error.

    Edouard

67. Paul Winter, on March 23rd, 2006 at 5:40 pm Said:

    To Bastien: Thank you for the reply. However the macro I am interested in “Convert formulas to their values” does not seem to be one of the standard buttons created when you build the ASAP toolbar. There appear to be a number of duplicate buttons but not the one I am interested in. I would like to specify the macro for a button by going through the Customize / Assign macro option but the only thing that shows up is ! (same for all buttons) so I don’t know how to point it to a different macro. Maybe the only solution is for the ASAP authors to fix the Build Toolbar function.

68. Alex Rodriguez, on March 24th, 2006 at 6:00 pm Said:

    Hello,

    Thanks to your hard work, the world (at least the excel users of the world) is able to enjoy great benefits with your program. Thanks so much.

    I ran into a snag with the latest beta version (3.11s). I just installed it and immediately tried the Export Worksheets as separate files (which is one I would be using very often, thanks for bringing this feature) and I ran into two problems:

    First, when I tried it on a spreadsheet with about 14 tabs, it seems that it works, but when I go to where I specified to save it, the files aren’t there. However, when I tried it again it says that the file already exists and if I want to overwrite them. Another issue here is that the radio buttons for selecting to overwrite is grayed-out. It only tells me that the file exists when I say ok and it proceeds to save the file, in which case it asks me to overwrite each file.

    So, I thought, may be that because I just installed the upgrade, that I should close and re-open excel and then try again. That’s when problem number two happened, when I load excel, the ASAP menu comes up while excel is loading, but shortly thereafter it disappears and doesn’t come back when it finishes loading. I go to Tools\Add-ins, and the option is selected, however.

    I tried re-installing and when excel opens, the menu is there, but the moment that I close excel and re-open it, again the menu disappears. I had to revert to the last beta that was working for me (3.11m).

    I’m using Excel 2000 on Windows 2000.

    Thanks much…………….Alex Rodriguez

    BTW: I had sent this to you via email. Then I realized that posting it here would have been more appropriate. Thanks.

69. Bastien, on March 24th, 2006 at 8:58 pm Said:

    Hello Alejandro,

    Thank your for reporting this. I have been working on it this afternoon. I’ve also enable the options to choose to overwrite existing files, skip or ask. I cannot explain or reproduce the problems you got after the error.

    At this moment I am also checking some other things.

    Probably this weekend but definatly monday I will put a new version online.

    Thank you for the quick testing en reporting,

    Kind regards,
    Bastien

70. Satish Dandekar, on March 27th, 2006 at 6:25 pm Said:

    This is a fabulous improvement in an amazing utility. With out ASAP excel is rudimentary. With ASAP excel is extraordinary

71. Jared, on March 28th, 2006 at 12:22 am Said:

    It would be great if there was an easier repository for building custom fuctions than writing VB. For example, I’ve always wanted to create a function that would take an email address and turn it into a URL. I know how to build this in Excel with the formula editor, but if I had to do it in VB I would be stumped. I’m not a good coder.

72. Bastien, on March 28th, 2006 at 3:05 pm Said:

    Hello Jared,

    To turn email adresses into urls you can use ASAP Utilities. Select the cells with the emailaddresses and then in Excel choose:
    ASAP Utilities » Web » Activate hyperlinks (create from cell-value)

    Extra functions in Excel have to be written as User Defined Functions (UDF). If you cannot do that you might find sites where you can download add-in with addinional Excel functions. ASAP Utilities has a few of them, but there are sites. If you need special functions a lot, spending some time in the Visual Basic editor might help, it is not that hard en there are plenty of good examples available on the internet.

73. Oscar, on September 19th, 2006 at 12:10 am Said:

    Absolutely love ASAP Utilites. Use it daily!!!

    I’m having trouble with Advance Sorting (Range\Advance Sorting). I use it a couple of times but now it only goes through the motion but doesn’t change the order. Is there a was to put number an a cell depending on the color of the cell? to created a value to sort on. i.e. green = 1 blue =2, red=3 orange=4 etc…

Leave a Reply