Make and Mail PDF files with VBA code on your Mac

Save as PDF in Mac Excel VBA examples

Below you can find example VBA code to save as PDF in Mac Excel. Microsoft fixed a few bugs but there are still a few of bugs to fix, so I will update the code when needed. The code will create a folder named PDFSaveFolder 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

If you want to create a PDF and also mail it check out this two pages :
Send Mail from Mac Excel with Mac Mail
Send Mail from Mac Excel with Mac Outlook

NOTE: Be aware that if you use VBA code to make a PDF in Mac Excel you are not able to print to paper after it anymore with VBA code like: ActiveSheet.PrintOut, I have reported this bug a long time ago, but it is still not fixed.

Web design by Will Woodgate