Run time erro 1004

Hi Guys

I am having problems with the below code. I am getting a runtime erro 1004 and excel is telling me that the path is not recognised(?!) yet i've checked the path and it is correct - can you help?

Dim strFilePath As String
Dim MyFilea As String
Dim LatestFilea As String
Dim LatestDatea As Date
Dim LMDa As Date

strFilePath = "L:\ClientInterest\BAD-STATIC DATA\NA-rates\"

If Right(strFilePath, 1) <> "\" Then MyPatha = strFilePath & "\"

MyFilea = Dir(strFilePath & "*.xls", vbNormal)

Do While Len(MyFilea) > 0

LMDa = FileDateTime(strFilePath & MyFilea)

If LMDa > LatestDatea Then
LatestFilea = MyFile
LatestDatea = LMD
End If

MyFilea = Dir
Loop

Workbooks.Open strFilePath & LatestFilea

Best,

Freddie