How to setup data connection with the protected website for downloading the internal content

[uday]

Hi All,

I want to create a data connection in Excel for below mentioned link. The main purpose of this connection will be to retrieve data or download different file from the website.

But whenever I am trying to set up a connection with the file URL, I can not able to download it because of its totally protected by User name and Password. Due to some security policy I can not disclose the Username and Password and the file URL.

Please help me to setup a Query request for the Username and Password. The link details is mentioned below.

The HTML string is-
"https://my.statestreet.com/main-smp...GET=-SM-https://my.statestreet.com/login/home"

If you have any other suggestion to automate to download the desirable file then please let me know.

Thanks......