Using an If stmt with an "Or"

[keith05281967]

Greetings,

I have some code that populates a column based on the file name. It strips out the extension and changes the "day" in the date to 01. That part works fine.

I'm having a problem when I tried to add another condition with the "Or".
I'm getting "object required" error 424. I'm sure i'm overlooking something in the syntax.


sFile = ActiveWorkbook.Name
sFile = Replace(sFile, ".xls", "")
If InStr(1, sFile, "CAT_") Or sFile.Value = "BIGDOG" Then
Mid(sFile, Len(sFile2) - 5, 2) = "01"
End If

any help is appreciated.

thanks,
Keith

 

[AlphaFrog]

sfIle is a string. Try something like this...

If InStr(1, sFile, "CAT_") Or sFile = "BIGDOG" Then


Or this if you want to make it case insensitive.
If InStr(1, sFile, "CAT_") Or UCase(sFile) = "BIGDOG" Then

 

[keith05281967]

thank you AlphaFrog.