Downloading PDF from a website. Excel 2013 Win7.

[Excelerate my work]

Hi guys, like the title says I am trying to download a PDF from a website. Here's the situation. The website with the PDF (is a SharePoint site, so I do not have access at home) requires you login and then enter the month/year from a drop down box. Once the month/year is selected, you click a button to create report. The PDF is opened in the same page. There is a hyperlink that lets you download the PDF but when it is clicked, IE asks if you would like to open, save, or cancel. At the moment I have the marco successfully open IE, login to the page, and creates the desired report I can also have the macro click the link, but this is where I get stuck. I cannot figure out how to make the macro save the PDF onto the desktop. I am not sure if it helps, but the website ends .aspx.

Also, if I physically right click the hyperlink, I can "save target as" and asks what to name the file, is there a way this could be made automated?

Any help would be greatly appreciated.

Thanks,

Tyler

 

[Excelerate my work]

Quick update: I have gotten it to work but it is not very...quick...I have macro open the PDF and sendkeys "^+s" Sendkeys "~". Is there a faster way to do that? if I select to save each month, it opens 7 pdfs and does that for each one. It works but it is slow.

 

[Excelerate my work]

Another update: Still using the sendkey method, it is slow but works. URLdownloadtoFile still not working..I will get the code up soon, it seems it will not let me declare the function.

 

[Excelerate my work]

Update! I've got URLDownloadToFile to work but when the PDF opens and is saved, it isn't saving correctly. The file on the desktop, when opened, says it is a corrupted file. Any ideas?