SOLVED

Query on Macros / VBA compatibility

%3CLINGO-SUB%20id%3D%22lingo-sub-3389564%22%20slang%3D%22en-US%22%3EQuery%20on%20Macros%20%2F%20VBA%20compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3389564%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20avoiding%20VBA%20%2F%20Macro%20like%20the%20plague%20as%20I%20am%20worried%20about%20compatibility%20issues.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20right%20to%20think%20that%20if%20they%20don't%20have%20the%20same%20version%20of%20Excel%2C%20like%20an%20older%20version%2C%20or%20a%20free%20software%20similar%20to%20Microsoft%20that%20handles%20excel%20files%2C%20that%20there%20might%20be%20major%20compatibility%20issues%2C%20and%20that%20avoiding%20using%20it%20makes%20files%20a%20lot%20less%20likely%20to%20be%20incompatible%2C%20or%20am%20I%20just%20being%20over%20worried%20over%20nothing%3F%20I%20want%20to%20learn%20and%20then%20possibly%20sell%20custom%20made%20files%2C%20and%20one%20bad%20review%20could%20be%20the%20end%20of%20a%20digital%20store%2C%20so%20I%20need%20to%20be%20very%20cautious%20with%20regards%20to%20maximizing%20compatibility%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3389564%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3389628%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20on%20Macros%20%2F%20VBA%20compatibility%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3389628%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1390664%22%20target%3D%22_blank%22%3E%40ShearaKLC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20things%20to%20consider%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EYou'll%20have%20to%20decide%20which%20is%20the%20oldest%20version%20of%20Excel%20you%20want%20to%20support.%20Microsoft%20has%20been%20adding%20lots%20of%20functionality%20to%20each%20new%20version%20of%20Excel%2C%20for%20example%20new%20worksheet%20functions.%20And%20in%20particular%20Microsoft%20365%20has%20very%20powerful%20features%20that%20really%20change%20the%20way%20Excel%20works%2C%20but%20that%20will%20fail%20on%20older%20versions.%20I%20think%20this%20is%20more%20important%20than%20VBA%20compatibility%20issues.%3C%2FLI%3E%0A%3CLI%3EYou'll%20also%20have%20to%20decide%20which%20platforms%20you%20want%20to%20support.%20In%20general%2C%20the%20Windows%20version%20of%20Excel%20is%20the%20most%20complete%20one.%20The%20Mac%20version%20is%20not%20that%20far%20behind%2C%20but%20it%20misses%20some%20features%20of%20the%20Windows%20version.%20Finally%2C%20the%20web%20(browser)%2C%20Android%20and%20iOS%20versions%20are%20much%20more%20limited%2C%20although%20Microsoft%20works%20hard%20to%20expand%20those.%20But%20VBA%20works%20only%20on%20the%20Windows%20and%20Mac%20versions.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have been avoiding VBA / Macro like the plague as I am worried about compatibility issues.

 

Am I right to think that if they don't have the same version of Excel, like an older version, or a free software similar to Microsoft that handles excel files, that there might be major compatibility issues, and that avoiding using it makes files a lot less likely to be incompatible, or am I just being over worried over nothing? I want to learn and then possibly sell custom made files, and one bad review could be the end of a digital store, so I need to be very cautious with regards to maximizing compatibility,

1 Reply
best response confirmed by JimGMac (MVP)
Solution

@ShearaKLC 

Some things to consider:

  • You'll have to decide which is the oldest version of Excel you want to support. Microsoft has been adding lots of functionality to each new version of Excel, for example new worksheet functions. And in particular Microsoft 365 has very powerful features that really change the way Excel works, but that will fail on older versions. I think this is more important than VBA compatibility issues.
  • You'll also have to decide which platforms you want to support. In general, the Windows version of Excel is the most complete one. The Mac version is not that far behind, but it misses some features of the Windows version. Finally, the web (browser), Android and iOS versions are much more limited, although Microsoft works hard to expand those. But VBA works only on the Windows and Mac versions.