I am using GetSession function to generate the session id as below. The below function is working fine on Excel 2003 but doesn't get the session id while running the macro in Excel 2010.
I have created al the needed certificates and macro runs fine in 2010 with HTTP, only getting problem with HTTPS
Any help or suggestion will be much appreciated.
Function GetSessionId(userName As String, password As String)
'Get the sessionId Dim objSClient As SoapClient30
On Error GoTo loginError
<CODE>Set objSClient = New SoapClient30</CODE></PRE>'Call objSClient.mssoapinit(par_WSDLFile:="https://10.101.20.14:443/wsdl/Query/gurj_web_q")
<CODE>GetSessionId = objSClient.Login(userName, password)</CODE></PRE>Exit Function
I have created al the needed certificates and macro runs fine in 2010 with HTTP, only getting problem with HTTPS
Any help or suggestion will be much appreciated.
Function GetSessionId(userName As String, password As String)
'Get the sessionId Dim objSClient As SoapClient30
On Error GoTo loginError
<CODE>Set objSClient = New SoapClient30</CODE></PRE>'Call objSClient.mssoapinit(par_WSDLFile:="https://10.101.20.14:443/wsdl/Query/gurj_web_q")
<CODE>GetSessionId = objSClient.Login(userName, password)</CODE></PRE>Exit Function
