2002 versus 2007 question

Otto Moehrbach

Guest

Posts: n/a

16th Jun 2009

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

« RE: Concate a range ignoreing blank cells | Re: 2002 versus 2007 question »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA for Excel 2007 versus 2002, Information	Neal Zimm	Microsoft Excel Programming	2	24th Dec 2009 04:44 PM
Re: 2002 versus 2007 question	Otto Moehrbach	Microsoft Excel Programming	0	16th Jun 2009 09:17 PM
Re: 2002 versus 2007 question	Rick Rothstein	Microsoft Excel Programming	0	16th Jun 2009 08:56 PM
Re: 2002 versus 2007 question	Rick Rothstein	Microsoft Excel Programming	0	16th Jun 2009 08:54 PM
Re: 2002 versus 2007 question	Bob Umlas	Microsoft Excel Programming	0	16th Jun 2009 08:47 PM