Missing Objects in Excel VBA

[Guest]

While running Excel 97 SR-2b, the object "Date" seems to dissapear from the
VBA references. It is access correctly until my Excel template is loaded.
Then the "Date" object is no longer found. I have reloaded Excel several
times. I even loaded another copy of Excel just to see if it would work.

 

[Peter T]

Maybe related to a missing reference in your template, in VBE see Tools >
References and uncheck any marked missing. You may need to replace with
similar avaiable in your system or for your version of Excel.

Without solving the real problem but as a workaround try:
MsgBox VBA.DateTime.Date

If you're also missing string functions try:
MsgBox VBA.Strings.Left("Hello",1)

Regards,
Peter