Excel / Outlook VBA to open attached PDF file

Hi All
I need your 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

AlphaFrog

Thanks for your help

I will try to use your code and let see what will happen

But in your code --> strName = MyMail.Subject & " " & Chr(45) & " " & Att.Filename <----- Chr(45) is it for me to enter the password ? let say if I would like to keep the password in cell(A2) in "Main" tab...how can I cope with your code?

thanks