Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2010
    Location
    Montreal, CA
    Posts
    32

    Unanswered: Creating Add-ins in Excel

    I have been programming with VBA for some time and would like to take the next step to improve the speed/efficiency of my code in Excel.

    I've seen suggestions on using C++.
    What do you guys think would be the most appropriate language?

    Thanks!

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    When I see people talking about using C++ instead of their usual VBA, it's normally for security reasons (secure code, not requiring users to enable macros, etc) rather than for optimisation. A well written XLL will run more quickly than a well written XLA, but the trade-off is that it is harder and more time consuming to write. I don't use C++ myself so I can't add further comment on it.

    I've just started learning C# 4; the introduction of optional parameters, not having to worry about PIA's etc... made it very appealing as an office developer, but it wouldn't be your language of choice if Excel performance is your goal.

    If the speed of your VBA routines is too slow then we could have a crack at optimising them?

  3. #3
    Join Date
    Feb 2010
    Location
    Montreal, CA
    Posts
    32
    you raise a good point; code security is actually a valid reason i am considering a change
    i am also considering standalone programs using VB in the .NET framework
    how would you compare C# to VB?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •