Create and Mail PDF files with Excel 2007/2010/2013

Excel 2007 : Office Button > Save As ….PDF    Or    Office Button > Send ….PDF
Excel 2010 : File > Save As ….PDF    or    File > Send ….PDF
Excel 2013 : File > Export > Create PDF XPS document    or    File > Share >Email >Send as PDF

In Excel 2010 -2013 the big round Office Button is replaced with File.

1) If you have also installed Acrobat Reader you can change OpenAfterPublish in the code to
    True to open the PDF file after you create it.
2) The mail code example is not working with Outlook Express or Windows Mail.
3) If you set OpenAfterPublish in the code to True then you can do a manual send in
    Acrobat Reader (also with Outlook Express or Windows Mail).
4) If there is no printer installed the add-in will not work. You only have to install a printer driver
    of one of the printers in the default printer list, you not need a real printer to use the add-in.
5) When you use a hyperlink to another place in the workbook or if you use the Hyperlink
    worksheet function the hyperlinks are not working in the PDF.