As MacXL/VBA Help states, ActivePrinter doesn't work in MacXL, the reson
being that the system call for printing doesn't allow it (it *should* be
scriptable, but Apple hasn't made it so).

Of course, you could manually save as PDF from the print dialog, as with
any other Mac application.




In article .com,
"Ty" wrote:

I'm trying to save (or print) a worksheet to PDF. I'm running Mac OS
X 10.3.9 and realize there's a compatibility issue with PC and Mac in
terms of .ActivePrinter application (see sample code below which was
used for this function on a PC). Is there a work around or some other
way to accomplish this in Excel (Office 2004) for Mac?

Simply, save a sheet as a .pdf file on a mac.

I've studied numerous posts on this subject but none of the code fully
fits my needs.
I'd greatly appreciate any help and guidance.