2002 versus 2007 question
 

I get 5 on my 2007 machine.
Code looks fine to me.

"Otto Moehrbach" wrote in message
...
I have Excel 2002 and I'm helping an OP who has 2007.
The following macro is a simplification of our problem but does
demonstrate the problem.
On my 2002 machine, the message box produces a 5. On his 2007 machine, he
gets a 0.
Sub TestInStr()
TheFile = "S12 Old.doc"
MsgBox InStr(TheFile, "Old.")
End Sub

What am I missing? Thanks for your time. Otto