Logging into a secure intranet for web query

[weirdaljr]

I have been attempting off and on for a few months to get Excel to log onto a secure site on a corporate intranet for a automated data export. I am not a VBA expert by no means and could really use some assistance. I have been able to research scripts online and modify them to different degrees to try and attempt to accomplish this, but I haven't been able to get it fully working on any of my attempts so I am now trying again.

Basically what I am trying to do is have the excel pull data from multiple intranet sites (lets call that site X) into multiple worksheets with a web query or other function with similar capabilities. Site X is a secure site the redirects to a login.html (lets call this site L) for authentication if the user has not recently authenticated. Site L is the same for all Site X due to the intranet using a single sign on web authentication portal (Oracle Access Manager/Netpoint if that matters)

The excel user will have proper authentication information, so I know I can have excel prompt for the user's login and password information, but I have not been able to get excel to recognize when it has been redirected site L to perform the login and maintain the secure web session to access the other data sites for each worksheet. I am starting fresh at this point again, all help, suggestions, and code to preform this is greatly appreciated.

Below is the code I pulled from site L with the login variables I thought were important to complete this:

document.getElementById('pcuserid').value = document.loginform.userid.value;
document.getElementById('pcpassword').value = document.loginform.password.value;
document.loginform.submit();

 

[joecracken]

Hello!! I am having this exact issue. I have two excel workbooks that I pull data from the company intranet but I can only be logged in to one workbook at a time. When I'm logged into one and then I log into the other, the first I was logged into will log me out and the query won't return any data. Were you able to get this issue resolved? If so, please let me know what you did.