Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference date for timesheet | Excel Discussion (Misc queries) | |||
Reference Date with Or Function | Excel Discussion (Misc queries) | |||
no reference date #ref! | Excel Discussion (Misc queries) | |||
Reference date as text | Excel Worksheet Functions | |||
reference to a bimonthly date | Excel Discussion (Misc queries) |