Sorry, a little late with the post but I thought I'd mention it to you anyway --

You could have just easily used the GetBaseName method of the FileSystemObject...

VB Code:
  1. Dim fso As FileSystemObject
  2. Dim sBaseName As String
  3.  
  4. Set fso = New FileSystemObject
  5.  
  6. ' this will return the name of the file without the extension
  7. sBaseName = fso.GetBaseName(sPathToFile)