SearchList

• For sSearchTerm, enter the search term string.
• For sColumnName, enter the column name string.
• For bExactMatch, enter true to match the search term exactly, or enter false to also return terms with different case or that contain the term.
  
  Examples:
  • If you specify exact match, the search term Jones does not retrieve jones.
  • If you specify no exact match, the search term free can also retrieve Free or freedom.

     Dim CS As Object
     Dim nNumRecords As Integer

     Set CS = GetObject(,“Connex.Client”)

     If CS.IsOnline = False Then
          CS.Logon ““, ““, ““
     End If

     If CS.Search(“WC”, “gon,wi,th,w/bks/1983-2003”) > 0 Then
          nNumRecords = CS.SearchList(“Margaret”, “Description”, False)

          MsgBox (nNumRecords) + “ records found”
     End If
End Sub

• Logs on to Connexion if not already logged on, using the default authorization and password you selected in Tools > Options > Authorizations tab.
• Searches WorldCat for the title Gone with the Wind in Books format only and only items published between 1983 and 2003.
• If the search retrieves multiple records (a brief list in this case), searches the description column of the list for any instance (not case-sensitive) of the term Margaret.
• Returns the number of records containing Margaret or margaret in the message X records found (where X = the number of records).
• Selects the records that contain the search term.