What are you doing still answering questions... don't you have to get ready
to go to AC sometime (I'm guessing) tonight? <g

I'm looking forward to getting together with you and Jon tomorrow night.

--
Rick (MVP - Excel)


"Bob Umlas" wrote in message
...
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