An Instr problem 2

[JamesBBB]

Hi All,

Could someone please tell me what is wrong with this statement, I cant see what Im doing wrong and its driving me loco.

Basically I have a string called ba which is being tested in a loop

when the string has "(s)" and "bytes" in it then code should be executed.

so when the string is:-

ba = " 644files(s) 1615377566772 bytes"

it goes through a test as follows:

If InStr(1, ba, "(s)") And InStr(1, ba, "bytes") Then
execute some code
end if

The trouble is, the above line is not finding the requested (s) and bytes.

Any ideas, many thanks

James

 

[combo]

If InStr(1, ba, "(s)")>0 And InStr(1, ba, "bytes")>0 ...

combo

 

[TonyJollans]

... or, probably (but not exactly the same) ...
[blue][tt] If ba Like "*(s)*bytes*" Then[/tt][/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[JamesBBB]

Thanks for the response guys, much appreciated.

Combo, I tried your solution and its now perfect

Many many thanks, you made my weekend

Cheers

James