Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating producing PDF of my Excel reports
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
Producing expense (monthly) reports in Excel | Excel Discussion (Misc queries) | |||
Generate Reports from Excel Using Seagate Crystal Reports PLs... H | Excel Programming | |||
Automating reports and printing | Excel Discussion (Misc queries) | |||
Producing charts from excel vba in Powerpoint | Excel Programming |