That's clever :)

--
Darren
"Tom Ogilvy" wrote in message
...
Great thought. Since you are using Instr


If instr(sfilename,".htm") Then ' any non-zero number is TRUE
sfilename = Left(sfilename,instr(sfilename,".htm")-1)
End if

--
Regards,
Tom Ogilvy



Darren Hill wrote in message
...
Maybe something like:

If Instr(sFilename,".htm") 0 then
If Right(sFilename,5) = ".html" then
sFilename = Left(sFilename,len(sFilename)-5)
else
sFilename = Left(sFilename,len(sFilename)-4)
End if
End if

--
Darren
"Jesse Hamilton" wrote in message
news:D0Srb.15952$jy.10631@clgrps13...
How would you code to truncate the .hml or .html from the tail end of
a
filename string?

Jesse