Anyone using the api with VB6?

[mrjonman]

Hello all!

I'm afraid that my expertise personally is limited to VB6. Anyone using
this antique besides me, a code example or two would sure be
appreciated!

Thanks!

[RedZone]

mrjonman:

If you don't have any experience with http/XML/SOAP controls, I would
highly recommend you try NSoftware's ActiveX control package.
http://www.nsoftware.com
Download IP*Works! SSL V6 ActiveX Edition
It has a great SOAP control, and you can drop any of the Google API
WSDL files into their Web Service Proxy Generator at
http://www.nsoftware.com/kb/apps/wspg/

This function will auto code the SOAP wrapper for you. Then you just
have to code the SOAPHeader property, and AddParam values for the
various G API functions you want to process.

This control set is very nice as errors are automatically trapped,
etc..
If you have any problems getting started sticky mail me - RedZone at
http://www.webmasterworld.com and we can get in contact, and I'll help
you get started...

Good Luck,

K.

[postm...@reducedfeeplans.com]

mrjonman,
Do you have any working code for the ipworks suitet,?
All I can get is "operation inturrupted"

[er...@nsoftware.com]

Here is some sample code for you :

http://www.nsoftware.com/kb/tutorials/adwords.aspx

-Eric

[mrjonman]

Eric

I've tried to run the sample code on your site at
http://www.nsoftware.com/kb/tutorials/adwords.aspx with no luck.

I'm getting an error, "Run-Time Error '20154' Specified URLScheme is
Invalid" when trying to run any of their functions.

Any help you can offer would be appreciated.

Thanks!

John

[er...@nsoftware.com]

Please make sure that you downloaded and installed IP*Works! SSL, not
the regular IP*Works! package. The Google AdWords API requires SSL
connections.

-Eric

[SimonN]

Eric,

I started trying to use the AdWords API today and came across this
thread. IP*Works looks like a very good solution but I am getting
exactly the same error as John. I have downloaded the SSL version of
IP*Works! and pasted in the first couple of code samples from the
AdWords tutorial page.

I am using the code within Excel 2002 running in XP with all service
packs installed.

Any help/suggestions would be greatly appreciated.

Thanks
Simon.

[mrjonman]

Hi Simon,

I gave up trying to use IP*Works. I just couldn't justify paying the $$
they want for the software for just the little bit of help it would
have given me with the AdWords API, had I been able to get it working.

I started to use the PocketSOAP toolkit and was able to get a
connection with AdWords established. I've been having the most luck
coding my own SOAP functionality directly in VB6 with MSXML 4.0. Since
it looks like you're using VBA within Excel that might not be an option
to you.

You might want to checkout PocketSOAP.com as an alternative. They also
have a Yahoo Group. http://groups.yahoo.com/group/pocketsoap/ Search
for AdWords in that group for a couple of relevent threads.

I'm definitley a newbie when it comes to XML & SOAP but if I can be of
more help, you're welcome to contact me at jmannATmannmadesoftware.com
(replace the AT with @)

John