VBA ExportAsFixedFormat Error

Nov 21, 2011
Reaction score
Hello Im trying to find a solution to this problem.

I am Using Excel for Mac version 14.1.2
My Operating system is OSX 10.7.2

I am using visual basics to export a sheet to a PDF file.
ActiveSheet.ExportAsFixedFormat pbFixedFormatTypePDF, "pathandfilename.pdf"

This works perfectly every time until i print from excel using the file>print menu button or clicking apple-p. I don't even need to finish the print job. I can click cancel from the print window and it will still cause that function that worked perfectly every time to fail every time.

Any idea why this is happening? and how to fix it?


Shop Amazon

Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.