I'm trying to make a Macro launch a link (to a PDF File), and open the file in a web browser, and then have a Save As Box pop up with the path to save folder already populated, and save as.

1) Check Locally for file (I can do this)
2) Launch Browser to Link (I can do this)

3) Set Save path (Can't do this)
4) Save Object Manually if not Auto. (Can't do this)

I tried forever to do the URLDownloadToFIle, but I never could get it to work. The website is protected by a SiteMinder Password Protect, so it redirects to the Username Password page, and then after signing in it goes to the link which seemed to block the URLDownload code from operating.