excel - VBA Excel : Like operator does not working correctly

Question

为什么Like功能不起作用？在这种情况下，它返回:

"No, it's not"

Sub test()
    If "*ыписка по договору ук-004#1500333*" Like "выписка по договору ук-004#1500333 стд.xlsx" Then
        MsgBox "Yes, it is!"
    Else
        MsgBox "No, it's not"
    End If    
End Sub

Answer 1

你有向后的字符串。

If {string} Like {substring w/wildcards} Then

Sub test()
    If "выписка по договору ук-004#1500333 стд.xlsx" Like "*ыписка по договору ук-004#1500333*" Then
        MsgBox "Yes, it is!"
    Else
        MsgBox "No, it's not"
    End If
End Sub