Date Reference in VBA
 

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

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

Date Reference in VBA
 

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



.