Help - Consuming Web Service in VBA

[Leon]

Hi,

I am very familiar with consuming Web Service using any .Net technology and
with the development of VSTO add-in but I am not too familiar with consuming
Web Service in Office VBA.

Can someone offer me some guidance? Apart from the Web Service Toolkit,
which appears to be obsolete now, does VBA naturally have support to consume
Web Service? If not what is my best options?

I need to cover Office XP upwards, what is the best recommendation? Write a
..Net COM component/add-in?

Thanks.

Leon

 

[Jonathan West]

Hi,

I am very familiar with consuming Web Service using any .Net technology
and
with the development of VSTO add-in but I am not too familiar with
consuming
Web Service in Office VBA.

Can someone offer me some guidance? Apart from the Web Service Toolkit,
which appears to be obsolete now, does VBA naturally have support to
consume
Web Service? If not what is my best options?

I need to cover Office XP upwards, what is the best recommendation? Write
a
.Net COM component/add-in?

Hi Leon

It appears that you can do this from VBA, and the following article should
set you on the right track

Calling XML Web Services from Office VBA Using the Web Service References
Tool
http://msdn2.microsoft.com/en-us/library/aa140260(office.10).aspx

If you do a web search for VBA and "web service" there are a bunch of other
articles which provide code examples.

 

[CyberPierre38]

Hi Jonathan and Leon,

I am after the same case of consuming a web service from VBA.
It seems that the Web Service References Toolkit was made for Office 2003.
As I am running Office 2007 and Vista, I get an error when trying to add a
Web reference (ie:"Please install IE 5 or higher" -
Did I miss something?
Or is this tool obsolete now and things diferent on Vista?
Thanks for your help.

Pierre.

 

[Mark]

I am looking also for some reference pointers, but could not find some
answers up to now.

It seems that there is two ways to use Web Services in Excel 2007.

1. VSTO SE
2. Web Services Tookit for Office 2003, not sure if this works with Excel 2007

Does anyone know what would be correct way to access Web Services from Excel
2007 without having to use Sharepoint Server 2007?

Thanks.

 

[HartyMcGra]

MS will not be supporting VBA or VB and are not actively supporting web
services in any of their products going forward. MS have determined that you
need to run managed code to perform the most simple interaction with a web
service and office. It just sells Visual Studio licenses and revenue is more
important than being able to integrate applications. Download OpenOffice and
move to Linux.

 

[msumrell]

Try the following article(s) in MSDN.

http://msdn.microsoft.com/en-us/library/aa902693(loband).aspx

This article Creating Managed Add-ins for Access 2007 is certainly targeted
at Access, but is applicable to other VBA-aware programs.