Web services

[Ed Peters]

Hi,

I've been searching around for info on web services using VBA and
there does not seem much about or its a few years old... although it
does seem possible...(found the Microsoft SOAP library).

I'm trying to pull off data from a website application that supports
API calls.

Thanks,

Ed

 

[Leith Ross]

Hi,

I've been searching around for info on web services using VBA and
there does not seem much about or its a few years old... although it
does seem possible...(found the Microsoft SOAP library).

I'm trying to pull off data from a website application that supports
API calls.

Thanks,

Ed

Hello Ed,

That's a pretty sketchy post. Can you be more specific about which
application you are referring to, and what type of information you
want to retrieve? Do you need to log on into this site? What version
of Excel and Windows are you using? This important when working with
API calls.

Sincerely,
Leith Ross

 

[Dana DeLouis]

I'm trying to pull off data from a website application that supports
Hi. I've looked into this also, but didn't have much luck. Mainly because
it's over my head.
It's a little easier to do in Math programs, but it's still way over my
head.

For example, to load Google, all I need to do is:

InstallService[http://api.google.com/GoogleSearch.wsdl];

If you can understand The Google Web APIs at the above link...Wow!!

I don't think Excel will make it that easy.
So, once loaded, I did...

GoogleSearch["Excel WebServices", MaxHits -> 10]

http://blogs.msdn.com/excel/archive/2005/11/17/493962.aspx

http://msdn2.microsoft.com/en-us/library/ms572330.aspx

etc...

So, apparently it is possible. Looks like it is done through Share Point
Services.
If you can figure it all out, please let us know. :>O
Good luck.

 

[Ed Peters]

Hi. I've looked into this also, but didn't have much luck. Mainly because
it's over my head.
It's a little easier to do in Math programs, but it's still way over my
head.

For example, to load Google, all I need to do is:

InstallService[http://api.google.com/GoogleSearch.wsdl];

If you can understand The GoogleWebAPIs at the above link...Wow!!

I don't think Excel will make it that easy.
So, once loaded, I did...

GoogleSearch["Excel WebServices", MaxHits -> 10]

http://blogs.msdn.com/excel/archive/2005/11/17/493962.aspx

http://msdn2.microsoft.com/en-us/library/ms572330.aspx

etc...

So, apparently it is possible. Looks like it is done through Share PointServices.
If you can figure it all out, please let us know. :>O
Good luck.
--
Dana DeLouis

Hello Ed,

That's a pretty sketchy post. Can you be more specific about which
application you are referring to, and what type of information you
want to retrieve? Do you need to log on into this site? What version
of Excel and Windows are you using? This important when working with
API calls.

Sincerely,
Leith Ross- Hide quoted text -

- Show quoted text -

Thanks, I use Excel 2003 and XP pro / 2000 and would need to login
(it's a shopping site).

However on further research I don't think Excel is the easist or best
way forward for webservices.

Thanks,

Ed