I have some vba Excel code that works when it is run on a windows 2000
OS PC But when I run the same code on an Windows XP OS PC I
get
Compile error can't find project or library

both PC have Office 2003 (Excel) installed

Debug brings me to



Code:
--------------------

Private Sub UserForm_Initialize()
txtCurrentDate.Value = Format(Now(), "mm/dd/yyyy")
End Sub

--------------------

If I get rid of the Format function it solves the error




Code:
--------------------

Private Sub cmdEmail_Click()
If Trim(Me.txtEmployeeName) = "" Then
Me.txtEmployeeName.SetFocus
MsgBox "Employee Name is a Required Field", vbOKOnly, "Required Field"
Exit Sub
Else
Worksheets("LeaveRequested").[C5] = txtEmployeeName.Text
End If

--------------------


If I get rid of the Trim function it solves the error



How can I resolve this issue so that my VBA code works on both Windows
2000 and XP OS???


--
cedtech23
------------------------------------------------------------------------
cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022
View this thread: http://www.excelforum.com/showthread...hreadid=563808

Toolsrefernces

it should have a checkbox and prefixing it should say 'MISSING'


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=563808