Date function - can't find project or library


  • My module won't run, it can't find the project or library, and highlights: the Date function in:
    MsgBox (Date).  This is happening to several VBA functions, but this is the first one.

    Any suggestions?

    Tuesday, April 28, 2009 6:05 PM

All replies

  • Hi, check under Tools References and see if Visual Basic for Applications is ticked, or if it is marked as missing.



    Wednesday, April 29, 2009 6:11 PM
  • Do you have more than one version of Office installed on the machine? The problem indicates a corrupt Office install.

    • Proposed as answer by question101 Tuesday, August 18, 2009 7:48 PM
    Tuesday, August 18, 2009 7:48 PM
  • As question101 said it occurs whenever there are multiple instances of Office is installed. you can overcome this by prefixing the class name of the function. In this case it would be datetime.Date

    • Proposed as answer by WhoStoleMyName Saturday, October 22, 2016 11:18 AM
    Thursday, August 20, 2009 12:22 AM
  • Hi I have checked this. It's ticked and not marked as missing. what's next?
    Saturday, February 15, 2014 10:12 PM
  • I was having a problem running the VBA Date and was getting same message.  The VBA library mentioned was also checked and not missing.  However, there was another library that I did not use that was checked, but marked as missing.  I unchecked it and the problem went away.  The missing library was from a valid third application that we use, but that had been uninstalled from that PC.
    • Proposed as answer by W. Ron Francis Wednesday, March 09, 2016 9:24 AM
    Wednesday, March 09, 2016 9:24 AM