Calling Google Web Service in VBA using Web Services Toolkit - Invalid OLEVERB structure error

M

mail_garp

Hi Folks,

I try to call the Google Web Service API (http://api.google.com/
GoogleSearch.wsdl) by using the Web Service Reference Tool and the
appropriated VBA code.

---------------
Public Sub testws()
Dim objGWS As clsws_GoogleSearchService
Set objGWS = New clsws_GoogleSearchService

Dim result As String
Dim MyLicenseKey As String
MyLicenseKey = "<mylicense key"
Dim Checkword As String
Checkword = "Vidual Basec"

result = objGWS.wsm_doSpellingSuggestion(MyLicenseKey, Checkword)

MsgBox "Search result:" & result


End Sub
-------------

Everything looks good, however, I get the following error when running
the code:
Run-time error '-2147221504 (80040000)'

Automation error Invalid OLEVERB structure

Any ideas what the problems are?

I am running this on Office 2003 - .Net Framework 2.0.

Thanks in advance for all replies !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Arrays of User-Defined Types w/Web Services Toolkit 3.0 0
Compile Error on Web Service Toolkit 2.01 code 4
Excel Macro VBA to Count Google Search Results 0
Trying to parse an Errors array which is part of an xml document froman xml service Options 1
Web Service in Excel 2000 1
Automation error, Invalid OLEVERB structure 0
Using Office 2003 Web Services Toolkit, invalid property assignment? 3

Top