VBA to open excel file from outlook

Hi,

I have emails come in daily to my outlook 2010 as an excel attachment, is there a way to open these attachement in excel by running a macro?

many thanks

Luke

What is the exact nature of your request?

As the easy way to open excel attachments in outlook is to double click them. Not really an action that requires automation.....

i will have the marco auto run when i get an email with an attachment

Im looking to use it with part of my formula that saves the file into certian workbooks

ok, what you need to do is set a 'rule' within outlook to run a macro whenever an email with an attachment arrives. The macro that's run must be in the VBA module of Outlook, not the Excel workbook you want to use.

You can set your Outlook macro to export any attachments to a specific file location, just Google that and you'll get plenty of examples.