How to Open Outlook Attachment in Excel using Excel VBA?

[Macro_Nerd99]

How should I Open an Outlook Attachment I receive on a daily basis in Excel using Excel VBA and based off the subject of the Email?
I also just set up a rule in Outlook to move that email from my Inbox to a folder automatically everyday, so would it be easier to open the attachment from the most recent email in that folder instead?

If so, how would you recommend doing this?

Thank you.

 

[ranman256]

can you not right click on attachment, then click 'Open'?

 

[thardin]

Yes, but I do this on a daily basis and wanted to automate this process as much as possible.