SSO Authetication using VBA

[AmeliePeter]

I am working on a excel macro that selects certain data from workbook and post it to a web service. For that I have to verify the users credentials with sso authentication of our companies main web application. Is there a way to do SSO authentication directly from the macro with excel vba?
I am new to Excel VBA programming. I have seen examples of sending HTTP request directly from excel VBA like this one. How can I send an HTTP POST request to a server from Excel using VBA?. But I am stuck at how to approach SSO authentication from excel using VBA.