Hi- My company used to work with quality center 12 .But lately they migrated to version 14 .Now, it is called microfocus 14.I had a tool created through VBA which used to work well with version 12 .This tool used to fetch various details like defects,test cases passed , failed etc.
In the VBA code for version 12 , the connection was initiated through method InitConnectionEx method.Parameter used to be server name(application link)

However , in the version 14, connection needs to be made through InitConnectionExWithCookies.Paramteres required are Server name and LWSSO cookie key.Now, the problem is, I know the server name but I am not sure how to fetch LWSSO cookie key. I am attaching the steps they provided in manual on how to get the cookie name.I am clueless on how to make it work through VBA.


image 1.PNG

image 2.PNG

Can someone please help?