save and email macro

[fishnic]

i need an excel macro that will do the following. when ran, it prompts the user for the filename and then saves it to the desktop. it then attaches to email and sends to test@test.com

it seems very complicated to me, but i know it will probably be a simple answer

thank you all in advance