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

Joined
Feb 25, 2015
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top