Extract Outlook 2013 attachments via Excel 2013 VBA

[crpjaviman]

Hi everyone,

I have been looking for some code that will find an email in a specific folder, open the attachment into Excel 2013, and save the report in a specified folder on a drive. I think I can handle the saving file part but the opening the attachment is kicking my butt. I would like to accomplish this via Excel and not, if possible, place any code into Outlook. This process will be passed on to other co-workers and I don't want to spend the time to install, format, and reference each time.

I have done it in previous version of Outlook and Lotus Notes, so I know it can be done. Any starting points for me?

Basic rundown: find today's email with an Excel report, either open the email and / or open the attachment (maybe both). Some of the files need to be opened due to the source that sent it. Once opened, I can do what I have to with them.

Any help will be appreciated.

Thanks,
crpjaviman