VBA excel错误将nvarchar值转换为int

I created a excel VBA code to get data from the server. It worked very well over a year. However, somehow one of the criteria has been changed about "refused name(no name)" customers. Before we used to assign customer number for them automatically, but with the new changes the system does not assign any customer number customer numbers for those customer instead it gives them "R/N" code. Therefore now I have some problem extracting data from server. I tried to apply some of those "by-pass techniques that I found on net but they did not work for me (talking about CAST). case WHEN isnumeric([CustId]) THEN CAST([CustId] AS int) else 0 endI created a excel VBA code to get data from the