Missing Objects in Excel VBA
 

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.

Missing Objects in Excel VBA
 

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

"Lawrence A Murdock" <Lawrence A wrote in
message ...
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.