Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Excel VBA Code to use Desktop, MS Office SSO to login to Fusion SaaS SSO — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Excel VBA Code to use Desktop, MS Office SSO to login to Fusion SaaS SSO

Question
73
Views
0
Comments

Summary:

Desktop, MS Office SSO to login to Fusion SaaS SSO

Content (required):

As per the link: https://github.com/VBA-tools/VBA-Web/issues/15

 We have the option to login to SSO sites using VBA code "WinHttp.WinHttpRequest.5.1" object and "SetAutoLogonPolicy (0)"

We tried to hit the URL: "https://login-XXXX.oraclecloud.com" in VBA with the code mentioned below, we got HTML response with status = 200. When we did hit the IDCS URL which has the SSO configured, we are getting 401 Unauthorized response. Is there any way we can login to Fusion SaaS using SSO of Excel in VBA?


Note:

My user is configured in Azure AD and IDCS for SSO and I am able to login to this environment using my Desktop/MS Office SSO from Web Browser. So no issue in User Management

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!