Just the ticket!, it was a "Missing" reference that seems
to have caused the problem. Many thanks.
Murray
-----Original Message-----
Hi Murray
"Date" and the other elements are all built-in and valid
in all versions.
Those problems are often caused by something else,
interfering with VBA's
"normal behavior". Like reference to a newer ADO library
than the one
installed. Or whatever not available.
On the non-working system, in the VB editor, go Tools
References and see
if something is marked "Missing". Try unchecking it/them
and see what
happens.
--
HTH. Best wishes Harald
Followup to newsgroup only please
"Murray Taylor" skrev i
melding
...
Which addin or reference provides the Date and Time
calls
in VBA?
I have a line in a procedu
Worksheets("System").Range("LastAccessDate").Formu la =
Date
which works fine on one installation of Excel 2000, but
generates an error "Cannot find profject or Library" in
another, and I am having a problem identifying the
relevant reference.
TIA
Murray
.