Problem Calling Current Date in Macro

Steve Hartman · Feb 20th, 2002, 04:38 PM

I have a macro that populates a userform when the workbook is opened. The following lines of code places the current date in a text box named TestDate:

With Me.TestDate
.Text = Date
End With

My problem is that this works on some machines and not on others. All the machines are running Excel 97 SR-1 with all the same add-ins. Any ideas what is causing the problem?

[ This Message was edited by: Steve Hartman on 2002-02-20 15:39 ]

Ivan F Moala · Feb 20th, 2002, 10:30 PM

Quote:

On 2002-02-20 15:38, Steve Hartman wrote:
I have a macro that populates a userform when the workbook is opened. The following lines of code places the current date in a text box named TestDate:

With Me.TestDate
.Text = Date
End With

My problem is that this works on some machines and not on others. All the machines are running Excel 97 SR-1 with all the same add-ins. Any ideas what is causing the problem?

[ This Message was edited by: Steve Hartman on 2002-02-20 15:39 ]

Steve, when you say it doesn't work on some
machines, what is happening...is there an
error or isthe format not right ??

Ivan

Steve Hartman · Feb 21st, 2002, 06:30 AM

Thanks for the reply.

Quote:

Steve, when you say it doesn't work on some
machines, what is happening...is there an
error or isthe format not right ??

Ivan

The macro is launched when the workbook opens. On some machines I get my Userform with the default values in the boxes. On the other machines I get the Microsoft Visual Basic error window:

Compile error:
Can't find project or library

the VBA editor is opened and Date is highlighted in the section of code that I posted earlier.

Steve

[ This Message was edited by: Steve Hartman on 2002-02-21 11:58 ]

Steve Hartman · Feb 21st, 2002, 01:00 PM

Any other ideas?

Steve Hartman · Feb 25th, 2002, 06:33 AM

Just a message to move this back up front in a last attempt to get an answer. ANYBODY ever seen this before?

Steve Hartman · Feb 27th, 2002, 04:07 PM

Finally figured this one out inderectly by stumbling around in the Microsoft Knowledge Base and wanted to post the solution to maybe save someone else several days of grief.

When the error occurs, you go into Tools>References in the VBA editor. This shows you a list of available reference libraries, with check marks by the ones your project is using I think. I had one checked that was listed as MISSING. (It was Microsoft Windows Common Controls 5.0(SP2) if anyone is interested) Simply unchecking this one solved the problem.

I still don't know WHY this occured since the error was occuring on both Windows/Excel 2000, Windows 95/Excel 97, and Windows 98/Excel 97 systems. On each of these combinations it would run on some machines but not on others. Interestinlgy, it would not run on the machine that it was initially created on and used to run just fine on! Go figure.

Just sign me formerly

[ This Message was edited by: Steve Hartman on 2002-02-27 15:07 ]

[ This Message was edited by: Steve Hartman on 2002-02-27 15:08 ]

[ This Message was edited by: Steve Hartman on 2002-02-27 15:11 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 04:38 PM	#1
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	I have a macro that populates a userform when the workbook is opened. The following lines of code places the current date in a text box named TestDate: With Me.TestDate .Text = Date End With My problem is that this works on some machines and not on others. All the machines are running Excel 97 SR-1 with all the same add-ins. Any ideas what is causing the problem? [ This Message was edited by: Steve Hartman on 2002-02-20 15:39 ]

Feb 21st, 2002, 01:00 PM	#4
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Any other ideas?

Feb 25th, 2002, 06:33 AM	#5
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Just a message to move this back up front in a last attempt to get an answer. ANYBODY ever seen this before?

Feb 27th, 2002, 04:07 PM	#6
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Finally figured this one out inderectly by stumbling around in the Microsoft Knowledge Base and wanted to post the solution to maybe save someone else several days of grief. When the error occurs, you go into Tools>References in the VBA editor. This shows you a list of available reference libraries, with check marks by the ones your project is using I think. I had one checked that was listed as MISSING. (It was Microsoft Windows Common Controls 5.0(SP2) if anyone is interested) Simply unchecking this one solved the problem. I still don't know WHY this occured since the error was occuring on both Windows/Excel 2000, Windows 95/Excel 97, and Windows 98/Excel 97 systems. On each of these combinations it would run on some machines but not on others. Interestinlgy, it would not run on the machine that it was initially created on and used to run just fine on! Go figure. Just sign me formerly [ This Message was edited by: Steve Hartman on 2002-02-27 15:07 ] [ This Message was edited by: Steve Hartman on 2002-02-27 15:08 ] [ This Message was edited by: Steve Hartman on 2002-02-27 15:11 ]