Compile Error: cant find library or folder (DATE) in VBA

[MrHydrant1857]

I am running a macro in excel and i am having trouble with this error popping up and highlighting the Year(DATE) formula in my vba. i have searched and searched and have found things on how to replace the referrences but i dont know what reference to use to solve this issue. my program runs perfect on one computer but not another. can someone please help.

 

[Joe4]

Go to the computer where it is running correctly on, go to the VB Editor, and select "References" under the Tools menu.
Note which references are selected.

Now go to the computer where it isn't working and do the same.
Does it have all the same references selected?
If not, select the missing ones (the version numbers may be a little different, just select the latest version available).

 

[MrHydrant1857]

the problem with the computer it is not working on will not let me select references. it is not highlighted. any reason that may be?

 

[Joe4]

Are they both using the same versions of Excel?
Is VBA enabled on that computer?

 

[MrHydrant1857]

i believe the excel where this program was created intitially is in Office 365 and doesnt really give a year. looks like 13 or 16. the excel where its not working is 2010. i am certain that the vba is for 2010 and newer. i was able to fix some of the compile errors with the (DATE) by just putting (vba.DATE). now it wont recognize Signature for the email code i have in it. from what i see this is all failing because its being run in excel 2010

 

[Joe4]

I don't understand what you said back here:

the problem with the computer it is not working on will not let me select references. it is not highlighted. any reason that may be?

If that computer has working VBA, you should be able to see and select References.

What references are selected on the computer where it works?
What references are selected on the computer where it does not work?

 

[MrHydrant1857]

what I meant by that was, the computer I am having the compile error is not letting me view the references. under tools the references is just grayed out so I cannot see what references are missing or not. the computer where the program works fine has these references: visual basic for applications, Microsoft excel 16.0 object library, OLE Automation, Microsoft Office 16.0 object library, Microsoft Forms 2.0 object library.

 

[Joe4]

That should not happen. See here: https://support.microsoft.com/en-us/help/856804/vba-editor-references-option-is-grayed-out

Are you, perchance, in break mode?
See here: https://www.mrexcel.com/forum/excel-questions/214952-tools-references-always-grayed-out.html