Hi all, I am using Excel 2010 and I need to create a macro (so I can assign to a button) that does the following:

1. Save the already set print area as Excel according to the contents of particular existing cells in a particular ws in that wb to the same folder.
2. Save a PDF of that ws to the same folder (or preferably if possible to a folder in that folder called Sent, to be created if not already there)
3. E-mail that PDF using the default e-mail app on the device with a specified subject and message content including the contents of one of the cells if possible.

I have searched and tried combining various codes I have found but I can't seem to get anything to work properly. Please help.
Andy