Left, Mid and Right functions not working on Office 2003

Hi,

VB in office 2003 does not seem to recognise the Left, Mid and Right functions. I've been using the code below to convert dates in excel like "20060123" to an actual date (i.e. 23/01/2006) in previous versions with no problem.

Sub DCDecToKhanya()
Dim mycell

For Each mycell In Selection
'For each cell in the range selected

mycell = DateValue(Left(mycell, 4) & "/" & Mid(mycell, 5, 2) & "/" & Right(mycell, 2))
'Convert the contents to a date

Next mycell

End Sub

I get a Compile Error " Can't find project or library"

Thanks

[662 byte] By [CReME] at [2007-12-24]