Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Better backward support for vba macros, it's ridiculous to have to write a new macro for each version of excel in a company.

1 vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
already supported  ·  Dan Battagin [MS XL] responded  · 

As long as you’re using functionality that exists in previous versions, macros should be backward compatible.

If you have a specific problem, please feel free to post it on UserVoice or on answers.microsoft.com.

Cheers,
Dan [MS]

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Kenneth Barber commented  ·   ·  Flag as inappropriate

    It sounds to me like this is your fault. If your macro is not backwards compatible, then you are using features that are specific to later versions of Excel. Since you know that your company has different versions of Excel, write your macros to work with the oldest version. If the oldest version is too old, try giving IT a talking to. I don't think that Microsoft will make their older Excel versions forwards compatible just to run your new macros.

Feedback and Knowledge Base