Check backwards comparability of macro enabled spreadsheet?

[qtmspin]

I have a 2016 macro enabled Excel file that is causing compile errors when run on 2013 Excel.

What is the best way to avoid error like that? Is there a compatibility checker? Or a 2013 emulator?

Thank you!
Matt

 

[jmacleary]

Welcome. I guess one way would be to develop your macro on the oldest version of excel it is supposed to run on. In this specific case, why not resolve the compile errors in 2013 and then see if its forward compatible to 2016? One point to consider is whether the errors are caused by missing or different dll add-ins. I have had issues with this in the past - you may just have missing dlls.