Using IF statement to recognize filename

[tim9525]

Dear Members,

   I am trying to teach Autoit to recognize several features in the file names. I tried the following two different methods using IF.....Then statements. But, none of them work. Can anyone please help?

Tim

Method 1:

If StringInStr($filename1, "plus2" ) > 0 Then  ; check if the filename is right
   Elseif StringInStr($filename1, "212") > 0 Then
   Elseif StringInStr($filename1, "252") > 0 Then
   Sleep(300)
   WinActivate("EXCEL")
   WinWaitActive("EXCEL")

 

Method 2:

If StringInStr($filename1, "plus2" or "212" or "252") > 0 Then  ; check if the filename is right
   Sleep(300)
   WinActivate("EXCEL")
   WinWaitActive("EXCEL")

[water]

I would try:

If StringInStr($filename1, "plus2" ) > 0 Or _
   StringInStr($filename1, "212") > 0 Or _
   StringInStr($filename1, "252") > 0 Then
       Sleep(300)
       WinActivate("EXCEL")
       WinWaitActive("EXCEL")
EndIf

 

[water]

BTW:
To work with Excel I suggest you try the Excel UDF that comes with AutoIt. Automating the GUI is always  a source of problems

[Factfinder]

If StringRegExp($filename1, "(?i)plus2|512|252") Then
    Sleep(300)
    WinActivate("EXCEL")
    WinWaitActive("EXCEL")
EndIf