Hi, my name is***** took a look at the link you provided, but you didn't specify what you were trying to get from the Web service, so let me point you in the right direction, since you're familar with VBA.
The easiest way is to use the WinHttpRequest object. For example:
Dim request As Object
Set request = CreateObject("WinHttp.WinHttpRequest.5.1")
request.Open "GET" "<theurl>" "<param1>" "<param2>"
answer = request.responseText
Hi there. Thanks for being more specific -- that's very helpful. (what you said previously is " want to connect Microsoft excel to a webservice to retrieve information based on a search term typed into a userform using vba." )
I guess I'm not sure what you want me to do or why you posted C# ***** here, when I thought you were doing it in Visual Basic? I provided some VB code for you to use to call the Web service. Did I miss something? Sorry if I did or am not understanding you well.
OK, I'll opt out and see if someone else can help you.