Hi All

I have an Excel report that my boss wants to send via email to staff
who are not in the office often.

The report is rather large 1MB and is sent twice a day so he wants me
to send it as PDF and not Excel for size reasons.

However I cannot automate printing to PDF with Distiller as it always
produces a pop-up asking where to create the PDF and what name to give
to it. I need to do this all from my VBA code so there is no human
interaction.

Is this possible with Distiller or do I need some third party
software?

Thanks in advance for any pointers,
Chrisso