Excel Excel VBA_Copy sheet to new workbook, save to desktop, then email

[mweber2222]

Hi,

I am new to VBA in Excel. I am trying to accomplish the following:

1. Have the following operation triggered by having the user click a "submit" button, then
2. Copy the active sheet to a new workbook
3. Save the new workbook to the user's desktop
4. Email the saved file to a standard email address, but with an editable subject line
5. (If it is possible to skip step 3, and still do step 4, that would be acceptable.)

I would appreciate any help that can be offered. Again, I am quite new to VBA, so simpler is better.

Thanks!

MW