Hi All,
We have developed Excel Macro which uses Webservices to talk to our application to generate the required data.
There is a GetSessionId function which get the session id by providing the Username and password. This was working fine with HTTP URL. Due to security reason we made our Application URL to HTTPS and started getting the error mesage.

The function return sessionid with http://loadbalancer:443/niku/wsdl/Query/ASP_RISKS_Q")
and ignore while usinh HTTPS i.e https://loadbalancer:443/niku/wsdl/Query/ASP_RISKS_Q")

below if the function
Function GetSessionId(userName As String, password As String)
'Get the sessionId
Dim objSClient As SoapClient30
On Error GoTo loginError
Set objSClient = New SoapClient30
Call objSClient.mssoapinit(par_WSDLFile:="https://loadbalancer:443/niku/wsdl/Query/ASP_RISKS_Q")
GetSessionId = objSClient.Login(userName, password)
Exit Function
loginError:
UserForm2.Hide
displayErrorFlag = True

End Function

Thanks in Advance.
Gurjeet