Outlook Rule - Save attached XLS and Run Macro??

[kennycad]

Hi,

I am looking for employee's to submit XLS timesheets via email. I would like to automate the process by doing the following:

The email arrives with the attached XLS timesheet.

Outlook rules filters the email, and runs a macro which saves the attached file to a specified ddirectory. Once saved, the macro opens the XLS and runs a macro within. Then close the XLS and delete it.

Any ideas?

Thanks in advance

 

[kennycad]

This has been worked out.

 

[neilholton]

Any chance you could tell me how?