How to make excel VBA as SAML client

AMBAR RAY 1 Reputation point

We have configured our Web API application to use SAML authentication, the identity provider being Azure AD v1.0 We wish to authenticate from excel VBA and call Web API by passing the SAML assertion returned post authentication to the request header of the Web API request. How to do it in excel VBA? Any code snippet and steps thereof would help.

Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
14,761 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,437 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Shweta Mathur 15,066 Reputation points Microsoft Employee

    Hi @AMBAR RAY ,

    Thanks for reaching out.

    Implementing SAML authentication in Excel VBA can be complex, and it's recommended to have a solid understanding of SAML and the Azure AD configuration. There is no direct reference, but you will find SAML and Azure AD configuration which you can used to implement your scenario.

    To implement SAML authentication in Excel VBA, you can use a SAML library that supports VBA, such as the SAML Toolkit for VBA from ComponentSpace and Configure the SAML settings for your application, such as the SAML endpoint URLs and certificate information.

    1. Use the SAML library to generate a SAML request and send it to the identity provider.
    2. Receive the SAML response from the identity provider and validate it using the SAML library.
    3. Extract the user attributes from the SAML response and use them to authenticate the user in your Excel VBA application.

    Hope this will help.



    1 person found this answer helpful.