Make and Mail PDF files with VBA code on your Mac

Save a file in Office for Mac. Use Excel for Mac 2011 to check out a SharePoint file so that only you can make changes. Explore other useful resources. Excel keyboard shortcuts. See the full list of keyboard shortcuts, organized into logical categories. Excel 2010 1 This chapter teaches you how to start an excel 2010 application in simple steps. Assuming you have Microsoft Office 2010 installed in your PC, start the excel application following the below mentioned steps in your PC. Step 1: Click on the Start button. Step 2: Click on All Programs option from the menu.

Below you find examples for Excel 2011 and Excel 2016 for the Mac, if you are a Windows user check out the code in the Win Tips section of my site.

Excel 2016 for the Mac

Save as PDF in Mac Excel 2016 (29-7-2017)

Below you can find example VBA code to save as PDF in Mac Excel 2016. Microsoft fixed a few bugs but there are still a lot of bugs to fix, so I will update the code when needed. The code will create a folder in the Office folder to save the PDF files in, read the info on this page why I use a folder in that location. Check out this page if you want an easy way to open this folder in finder : Setup your Mac for Mac Office 2016

Save as PDF and attach to mail in Mac Excel 2016

Mac Outlook 2016 with Mac Excel 2016:

For Mac Outlook 2016 mail code visit this page for examples files and Add-in (1-Feb-2019)

Mac Mail with Mac Excel 2016:

For Apple Maill code visit this page for examples files (1-Feb-2019)

Excel 2011 for the Mac

Download the example workbook below with a few example macro's to create and mail PDF's in Excel 2011. Please test it and give feedback, good or bad. There are Mail examples in the workbook for Apple Mail and Outlook 2011.

Excel 2011 Mac Manual Pdf Online

Download example file : 29 Nov 2015

Note: Fixed a bug that it not attach the pdf to the mail when you use El Capitan as OS X.

Microsoft Excel For Mac 2011

Double-click the dmg file if it does not mount automatically. Drag the file to the folder you want on your Mac. Tip: Use one folder for all your example files (easy to backup your files this way)

Note: When you add new worksheets to the workbook the example code to make a PDF of the whole workbook do not include that sheet or sheets until you Close/Reopen the file.

There are a few problems(bugs) If you use VBA SaveAs or ExportAsFixedFormat or save a workbook manual as PDF. When you save the workbook as PDF it wil create a seperate PDF for each sheet in the workbook and it also add a sheet name to the file name of the PDF when you do it manual or with code.

My workeround is this :
because creating a pdf of each sheet only happens the first time when you run the code I do this :

1: Create the PDF in a Temporary folder (code will create that for you)
2: Delete all files in this folder
3: Create the pdf again
4: Rename the PDF file (remove the sheet name)
5: Move the file to the folder you want

More Mail Examples

Excel 2011 Mac Manual Pdf Free

For more information and examples about mailing with VBA code from Mac Excel visit : Send Mail from Mac Excel