move Excel attachments in email to a folder

Hi,

I'd like to move Excel attachments in email to "My Document" folder.
All excel attachments have the same format. Every morning employees send emails including excel attachment.
I think I can open each email then, save excel attachment to "My Document", but I wonder macro can help
this work.
Is this possible in excel?

Thanks

I will try but first let me know are you using ms outlook ??

many thank
Rishi Saw

hey I try to prepared I vba code

it is applicable to outlook only ( also outlook should be closed and as a background application)

Please Login or Register  to view this content.

Thank you for your time!

Should I write this in module and use button to perform this in excel? Is this right?
Sorry for my silly question but I am a beginner in Excel VBA.

Thanks

yes pls pls press alt and f8 then insert module then paste the code and hit f5

Thanks! I'll try!