ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SAP Late Binding Problem (https://www.excelbanter.com/excel-programming/349929-sap-late-binding-problem.html)

msnews.microsoft.com[_10_]

SAP Late Binding Problem
 
I am trying to use SoapClient30 to acces a web service. If I use the
following with a reference set to the Microsoft Office Soap Type Library
v3.0, this works fine:

Dim objSClient As New MSOSOAPLib30.SoapClient30
Set objSClient = New SoapClient30

However, I do not want to make all users have to select the reference, so I
want to late bind. I have tried the following:

Dim objSClient As Object
Set objSClient = CreateObject("MSOSOAPLib30.SoapClient30")

When I do this I get an error that states the "ActiveX component can't be
created."

Any help is appreciated.




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

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