Open a Webpage, Log In, and Close it again
<p>I want to prepare daily reports from a particular JSON file. My plan is to download the file through VBA, then write a macro that automatically generates the report. </p>

<p>The problem is that the JSON file sit behind a Single-Sign-On authentication protocol. For various reasons I just do not want to VBA myself past the SSO. </p>

<p>What I would like to do is:
1) Have VBA open the address for the JSON file. 
2) If I'm not already signed-in, open the browser window for the SSO page so I can manually put in my credentials.
3) Once the JSON file is open - if I'm already signed on and the data is there, to close the browser window and download the data to a particular location.
4) call the other macro so the report can be generated.</p>

<p>A: Is this possible?</p>

<p>B: How?</p>