Btw; what's wrong with you people? we need moar S P A M
Set objVendorFind = oBAPICtrl.Add("BAPI_VENDOR_FIND") objVendorFind.exports("MAX_CNT") = "2" objVendorFind.exports("PL_HOLD") = " " Set obTblVendor = objVendorFind.Tables("SELOPT_TAB") obTblVendor.FreeTable obTblVendor.Rows.Add obTblVendor.Value(1, "COMP_CODE") = Values(0) obTblVendor.Value(1, "TABNAME") = "LFA1" obTblVendor.Value(1, "FIELDNAME") = "STCEG" obTblVendor.Value(1, "FIELDVALUE") = Values(4) If objVendorFind.Call Then iVendorCount = 1 Set objTable = objVendorFind.Tables("RESULT_TAB") If objTable.Rows.Count > 0 Then If objTable.Rows(1).Value("VENDOR_NO") <> "" Then Set objVendorDetail = oBAPICtrl.Add("ISIDE_CE_VENDOR_READ") Do If Values(2) <> "" And iVendorCount = 1 Then objVendorDetail.exports("IF_LIFNR") = Values(2) Values(2) = "" Else objVendorDetail.exports("IF_LIFNR") = objTable.Rows(iVendorCount).Value("VENDOR_NO") End If objVendorDetail.exports("IF_BUKRS") = Values(0) If objVendorDetail.Call Then Values(1) = objVendorDetail.imports.Item("ES_LFA1").Value("NAME1") If (LCase(Left(Values(1),2)) <> "xx") Then If Values(2) = "" Then Values(2) = objVendorDetail.imports.Item("ES_LFA1").Value("LIFNR") Else Values(2) = Values(2) & ";" Values(2) = Values(2) & objVendorDetail.imports.Item("ES_LFA1").Value("LIFNR") End If End If If InStr(Values(2),";") Then Values(6) = "Meerdere crediteuren gevonden met dit BTW-nummer." End If End If GetDetailSAP = True iVendorCount = iVendorCount + 1 Loop Until (iVendorCount > objTable.Rows.Count) Else Values(6) = "Er is een crediteur gevonden zonder crediteurnummer." End If Else Values(6) = "Er is geen crediteur gevonden met dit BTW-nummer." End If Else Values(6) = "Er is een fout opgetreden." End If