How do you open a link to a secure website with VBA in Excel?

I am trying to create a macro to open several links from a secured website (meaning login and password are required when normally accessing the site). Each link would normally export a report to the download folder if already logged into the site, but the goal is to have other users with their own website login credentials to be able to utilize the macro. I'd have other vba coding to utilize the downloads and update a report in excel. This basically consolidates information from the website into one page, as opposed to navigating through several webpages for information. Also, it appears the links to the downloads contains an "access token", so I'm assuming I can't use a static link in the macro. Any thoughts or direction appreciated. Thanks