Many errors when running 2007 code in 2016

[earldunning]

From what I understand there are many functions in the 2007 code that are no longer supported in 2016.
Does anyone have a master list of things that no longer work in 2007 and what it needs to change to in 2016?
Otherwise I would need to research every error individually.

Example:

DateToday = Format(Now, "m/dd/yyyy")

This actually errors on the "Format." I have many other instances of errors when using 2007 code in 2016.

Master list anyone?
Thanks

 

[Norie]

Format is definitely supported in 2016 and I've not heard of many (any?) standard functions not supported in 2016.

What's the error when you run that code?

 

[earldunning]

Compile error: Cannot find Library or Project

If we leave 2007 and 2016 both on the system, and run it in 2016, it doesnt error. But if we run it in 2016 without 2007 installed, it errors. It seems like its looking for libraries from 2007. (but cant leave both on anymore)

 

[Norie]

I think if you want/need to have multiple different versions of Excel on the same machine you need to install them in a certain way.

I've never had to that, or felt the need, and the only problems I've never had any problems when moving to the newer version.

In the workbook you have the problem with Format what do you see when you goto Tools>References...?

 

[earldunning]

Yes, we actually installed them in a certain way to keep it running lately. But now we have no option but to remove 2007.
Once you said it should work, I researched more and found a person that had a similar issue. They also referenced Tools/References.
You were right.
Tool/References had "MISSING: 2007 Calendar Control." Once I unchecked that and saved, everything seems to be working again!!!

Thanks for the help!!

 

[Norie]

No problem.

Mind you, one of the things that is missing from Excel 2016 are controls like the Calendar Control so if you have any workbooks that used those type of controls you might have some problems.