none
Date function - can't find project or library

    Question

  • 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.

    Regards

    ADG

    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

    Cheers
    Shasur

    http://www.vbadud.blogspot.com
    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