+ Start a Discussion
BingBing 

Filter issue: Always receive "Type Mismatch" error regardless what filter is applied

Dear All,

 

I am desperately lookin for help.

 

I am using Force.com Connector for Excel version version 16.03.  It works perfectly as long as I don't apply any filter.

 

Regardless what filter I applied, I alway got error message "Could not set the list property. Type Mismatch"

 

For example,  I tried

Account Name starts A

or

Account Name starts "A"

 

When I do debug, it highlights line 4 in the code below.

 

Sub AddClause(clauseNum As Integer) ' 5.42
    With Me.queryClausesList
        .AddItem clauseNum, clauseNum
        .List(clauseNum, 1) = Selection.Offset(0, 1)
        .List(clauseNum, 2) = Selection.Offset(0, 2)
        .List(clauseNum, 3) = Selection.Offset(0, 3)
    End With
End Sub

 

Please kindly help.

 

Thanks

Bing

 

BingBing

Okay, I just found out the root cause.

 

The filter functin doesn't work with German locale settings (e.g number format: 7.000,09)

 

I changed my PC's Regional Data Format to English (United States) , then it works.

 

Cheers

Bing