ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Consuming a web service in Excel 2003 that requires a certificate (https://www.excelbanter.com/excel-programming/342540-consuming-web-service-excel-2003-requires-certificate.html)

[email protected]

Consuming a web service in Excel 2003 that requires a certificate
 
I am trying to consume a webservice in Excel 2003 via VBA.

I am using Microsoft Office 2003 Web Services Toolkit to create a proxy
to interact with the webservice. So far so good, but...

The webservice needs a certificate (which i have) but i cant figure out
how to implement it in the code.

I have found an example for Word, but the same code cannot be used for
Excel, as Signatures is not a member of ActiveWorkBook

Code (Word):

Dim sig As Signature
Set sig = ActiveDocument.Signatures.Add


Can anyone help me?



All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com