Stripping off char from string

[Mark]

I want to strip of the ".txt" extention from a file name.
Example:

MyPath = Dir(c:\*.txt)

' MyPath could eqaul something like DC123RE.txt

myresults = ????(MyPath)

I want MyResults to be "DC123RE" minus the .txt.