use excel/outlook VBA open PDF file(password protected but have password to open it) and then click the link(on pdf file ) to open the file

[bnfkru4567]

Hi All
I need your Excel Excel/Outlook VBA expert to help.

I knew how to build up outlook VBA to detect new email with attached file (i.e. PDF file) coming in the specific folder but have the following problem :

The email has attached file that is PDF file with password protected. (I know the password to open it). Under the PDF, there is link/icon and use mouse to click on it and then a small window coming up to choose either open or save the excel file or not into computer. Of course, "save the file" into computer.
However, how could I write up excel/ utlook VBA to do all the above steps automatically ?

I am using Outlook 2013.

Thanks for your help in advance

 

[bnfkru4567]

Please help