All geek questions in one place

Excel 2007 - Conversation with Web Service

I have been using Excel 2003 'Web Services Toolkit' for some time to write spreadsheets that connect to external web services through VBA.

(i.e., you install the web services toolkit that adds the Web Service Links ... item to the Tools menu. Then you set the link to the web service URL, and the Toolkit writes the necessary proxy classes in VBA to connect to you. Then the web service methods are displayed in VBA.)

Excel 2007 does not have this “set of web services” - or at least I cannot find anything like it. I note that my Excel 2003 sheets work fine in 2007, so the hooks I need are somewhere in there.

Which brings me to my question - what is the approved way to communicate with external web services in Excel 2007? I can not find anything useful on the Internet?

Thanks...

Sal

+3
source share
1 answer

You have several options:

1) Microsoft Office v3.0 mailbox type library (as mentioned above). Nice and simple, works well in VBA, is completely useless because it does not support WS-Security. If you use SOAP without WS-Security, you are wasting time.

2) C # lib opened in Excel using COM Interop. It is relatively simple to demonstrate the assembly for use in VBA - allows you to use WSE 3.0 / WCF in VBA. The assembly must have a strong name.

3) Visual Studio. # ( CLR) . , .NET Excel ( Word, PowerPoint ..). Visual Studio Team Suite.

( HTTPS), , , MMC snapin . , , .NET .

+4

Source: https://habr.com/ru/post/1710994/

More articles:


All Articles