EXCEL VERSION COMPATIBLITY

[jigishapatel]

Hi,

I have an issue with Excel compatibility. I have created a excel form with various sheets using macros in excel version 2016, However the end user has excel version 2010. The user is getting an error like " Cant Find project or Library" and "Compile error in hidden module". Not sure how do i get this error recitified and make the file compatible with excel 2010 version.

Look forward for your help.

Thanks.

 

[CountTepes]

If it works in 2010, it should work in 2016. 2016 is not radically different but has extra functionality.

Your best bet, would be to get a copy of 2010. Get everything working in that, then it should work in 2016 without modification.

 

[MARK858]

Cant Find project or Library

Reset the code, Click Tools - References and see if any are marked as missing.

 

[jigishapatel]

If it works in 2010, it should work in 2016. 2016 is not radically different but has extra functionality.

Your best bet, would be to get a copy of 2010. Get everything working in that, then it should work in 2016 without modification.

I think you misunderstood. I would like to downgrade my file (made in 2016 version) to work in 2010 version.

 

[CountTepes]

What you would need to do, is get your file onto 2010, trace through where it fails and fix those bits of code. You are most probably using some code which has been added to or changed in 2016, compared to 2010. 2010 used VBA 7.0 where as 2016 uses VBA 7.1.

The biggest differences though, are the built in Excel functions. Are you using functions which are in 2016 which are not in 2010?

There is information here which may be of help. Excel Functions List

As far as I know, there is no way to check for VBA 7.1, but application.version will give you the version of excel. There are also built in compiler constants, so if the version of excel does not have the built in function, you can build it yourself inside of a #IF THEN, #ELSE, #END compiler directive. So it will only exist if your version of excel needs it.

The list is here Compiler constants (VBA)