ChristoP


Is there a piece of example code that shows how to use the MSN Search API from VBA I'd prefer one that doesn't require a web server proxy.



Re: MSN Search API client in VBA?

ChristoP


What I've been able to do so far has been to create a web reference to the MSN search wsdl file. This created five classes in my project. I will look at the Perl example to see if I can figure out what objects to create, and how to use them.





Re: MSN Search API client in VBA?

ChristoP

Here is my code:
Code Snippet

Dim o As New clsws_MSNSearchService
Dim req As New struct_SearchRequest
Dim source As New struct_SourceRequest
req.AppID = sAppID
req.CultureInfo = "en-US"
req.Query = "My search query"
req.SafeSearch = "Off"
req.Flags = "None"

source.source = "Web"
source.Offset = 0
source.Count = 10
source.ResultFields = "All"

Dim theRequests(0 To 0) As Variant
Set theRequests(0) = source
req.Requests = theRequests
Dim response
response = o.wsm_Search(req)



It fails at the last line with "SoapMapper:Restoring data into SoapMapper Responses failed". I believe the AppID is valid. Is there a way to check this