Heray-Was-Here
Server : Apache
System : Linux vps103298.mylogin.co 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64
User : calvet ( 273824)
PHP Version : 7.4.33
Disable Function : NONE
Directory :  /usr/share/doc/perl-SOAP-Lite/examples/COM/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //usr/share/doc/perl-SOAP-Lite/examples/COM/remote.vba
Function GetSOAPObject() As Object
  Static SOAPObject As Object
  If SOAPObject Is Nothing Then
    Set SOAPObject = CreateObject("SOAP.Lite").new
    If SOAPObject Is Nothing Then
      MsgBox ("Oops, no SOAP.Lite on this machine")
      Exit Function
    End If
    SOAPObject.proxy("http://soaplite:authtest@services.soaplite.com/auth/examples.cgi").uri ("http://www.soaplite.com/My/Examples")
  End If
  Set GetSOAPObject = SOAPObject
End Function

Sub GetStateNameRemotely()
  Application.StatusBar = "Running SOAP call..."
  Range("Current").FormulaR1C1 = GetSOAPObject.getStateName(Sheet1.TextBox1.Value).result
  Application.StatusBar = False
End Sub

Hry