View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Date Reference in VBA

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