I have struggled for awhile now designing a excel script that can login to a company intranet site for a data export. The company uses Oracle Access Manager (Netpoint) for use of single sign on accounts for authentication. I have tried modifying multiple scripts available online for secure authentication with slim success.

My goal is to get Excel to be able to import data from the designated intranet sites automatically for manipulation without having to log into to site manually through the browser.

All webpage requests redirect to a login.html were I pulled this code containing the login variables used:
Please Login or Register  to view this content.
I do not know if it is relevant, but the login.html seems to validate through a webgate.dll (part of OAM/NetPoint) on the backend.

Any assistance with accomplishing this is appreciated.