Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2002 versus 2007 question
I'm assuming the filename is being read from the system... perhaps it is in
lower case on the 2007 computer. Try the MsgBox line this way and see... MsgBox InStr(1, TheFile, "Old.", vbTextCompare) -- Rick (MVP - Excel) "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2002 versus 2007 question | Excel Programming | |||
2002 versus 2007 question | Excel Programming | |||
UserInterfaceOnly in 2000 versus 2002 | Excel Programming | |||
Excel 2003 versus 2002 seem incompatible related to the EDATE fun. | Excel Worksheet Functions | |||
Excel 2000 versus Excel 2002 question | Excel Programming |